missing record number

G

greenjeans

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
 
J

Jerry Whittle

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

John Spencer

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