Did you remove the entire record of just the data within the Customer ID
field? If you didn't remove the whole record, the query is probably working
just fine.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"greenjeans" wrote:

I am new to access and I have removed a record from a "Customer ID" field and
now when I run a query it shows 24 records and there are only 23, which makes
all records after the deleted file off by one , is there a way to correct
this ....

Thanks in advance