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.