Changing the starting value of an AutoNumber field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Does anyone know how to change the starting value of an autonumber field
from 1 to 110??

I am entering existing projects into my project table, however the project
codes start at 110. I am required to keep the existing project codes.

Any ideas?
Any help would be greatly appreciated.
Thanks, Michael
 
Create an append query to add one record to the table. Include the
autonumber field in the output field list, and set its value to one less
than the number you want the next record to get for the autonumber. Run the
query. Then you can add new records that will begin with the next autonumber
value. You then can delete the originally added record.

Note, autonumbers are not guaranteed to be consecutive, not to have gaps,
etc. If your records need an ID that has a specific, non-gap value, you
should not use autonumber type, and instead create your own values for a
Long Integer field for new records.
 
Back
Top