Do you mean that you used an autonumber field as the id field and now you
have a gap in your numbers because you deleted a record?

If that is what you mean, then you have no way to "correct" this.
Autonumbers are not re-assigned when they are deleted.

"greenjeans" wrote in message
...
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