Can you start an autonumber data type at say 1000

  • Thread starter Thread starter rayebersole
  • Start date Start date
R

rayebersole

Sorry I will repost this post also (just new to the group)

Can you start an autonumber data type at say 1000 and let it count up
1001,1002 ect
 
The easiest way is to append 999 dummy records and delete them. Then add
your data.
Click to expand...

Actually you only need to append *one* record, with 999 as a Long Integer in
the field you're appending to the autonumber field. You can then delete the
record and it will have set the seed.

Depending on your Access version, you may also be able to set the autonumber's
Seed Value property.
 
Back
Top