Can you start an autonumber data type at say 1000

[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

 

[KARL DEWEY]

The easiest way is to append 999 dummy records and delete them. Then add
your data.

 

[John W. Vinson]

The easiest way is to append 999 dummy records and delete them. Then add
your data.

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.