missing record number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Access Dcount (multiple criteria) 3
Copying Records 3
Query for Records AFTER Certain Time on a Certain DATE ?? 4
acnewrec? 1
Unique values in two fields in query 1
Record insert/delete anomaly 0
Generating a new Record 14

Back
Top