Why every time my Access Database Autonum field never shows me 1,2,3....?

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I just built an Access Database and set the 1st column as Autonum fields. It
starts with 1, 2, 3 at the begining, however after I deleted all
records(total 5 records) and add new records, the new one didn't start with
1, 2, 3 as it should be. Insteadly it starts with 6, 7, 8. Does anyone know
how to let my database automatically set my first record's autonum field
back to 1, I don't want see 6 or 7 at the beginning of my table.Thank you!

The Best Regards
Paul
 
Autonumber is not guaranteed to be sequential, just unique. If you need
sequential numbers that will be seen by your users, create a number field
and increment it by one for each new record.
 

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

Back
Top