I am converting an old dos database to ACCESS 97. In that program it was OK to have missing invoice numbers. It still provided the user with a sequential number each time. In ACCESS 97, can you begin to autonumber from a starting point without changing the data type. Macro, Code whatever is OK.
K

to set an autonumber to start at a number just do an append query setting the Auto number = the number just before the number you want to start with.

"Input Into tblTest (ID) Values(99)"

This would start the Autonumber at 100.