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