Setting AutoNumber to a higher number

[rwmixer]

We have a new database for a new project, but the numbering all starts at 1,
We would like to change the numbers to something higher but I am unable to
find afeature that allows such action. Any help would be greatly appreciated

 

[BruceM]

Here is a way of doing that:
http://allenbrowne.com/ser-26.html

Be aware that you will almost surely end up with gaps in the numbering, if
that is a consideration.

 

[SigiS]

Try an append query.

1. Create a table with a number field and type the starting number that you
want to use ex: if you want numbering to start at 2001 then use 2000 as the
number that you type into the number field
2. Create an append query and append the number field to the auto # field