Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Access 2003 problem with wrong totals

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 18 Oct 2007 23:04 GMT
Please bear with me as I try my best to describe a problem we have with our
Access 2003 program. I didn't create our system but I do use it daily.

We're using Access 2003 (I don't know the version) for a simple inventory
program. We have 12 fields that has 10 items (entries) each. All 12 equal
120.  If we move one of the ten items "out" in any of the 12 fields, the
count drops to 9 for that field. But, one of the field shows 11 items when
there are only 10 entries. There is always one over.

Our ''out" count is always correct. It's like there is a ghost item that we
don't see.

Any ideas what might be the problem?

Thanks for any and all help.
mscertified - 19 Oct 2007 02:01 GMT
You need to explain more clearly.

How are the totals being formed, on a form, in a query, in a report?

"We have 12 fields that has 10 items (entries) each"
-What does this mean? How can a field have 10 items?

"If we move one of the ten items "out" in any of the 12 fields"
What does this mean?

-Dorian

> Please bear with me as I try my best to describe a problem we have with our
> Access 2003 program. I didn't create our system but I do use it daily.
[quoted text clipped - 11 lines]
>
> Thanks for any and all help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.