Access 2003 problem with wrong totals

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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.
 
Hello Dave.
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?
Click to expand...

2003 is the version of Access 2003.
To find the ghost it can be helpful to know the formula that counts
the values, and also where the formula is placed.
Probably someone entered something like 1+Count([TheField]).
 
Back
Top