Access 2003 problem with wrong totals

[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.

[Patrick A]

No way to tell without seeing the database structure and
relationships, but it is possible that the count is based on linked
tables, and removing the item from "Table A" does not remove the item
from "Table B". If the count is based on a combination of Table A and
Table B, that could account for the number being off.

If you can reply with more info on the structure of your database, the
relationships between tables, and the SQL for the counts (assuming the
counts come from queries), that might help others help you.

Patrick