Auto Number Starting Other Than ONE

[Morgan Bearden]

How does one get an auto number field to start with a
number other than one?

I organize an atheletic event in which each participant is
given a unique number. This year our numbers will start at
101 rather than one and I need to haave the proper number
in the database. I can't seem to change the auto number
from starting at one.

Thank you --- Morgan

 

[Allen Browne]

There are a couple of ways to do this, but firstly, you are aware that
AutoNumbers give you a unique number, not necessarily a sequence of numbers?
For example, if someone begins adding a new record and aborts, that number
will never be reused.

An approach that works in all versions is to use an Append query statement
to add a record with the value 1 less than you want, and then delete it.
Details in article:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

Another approach that works in Access 2000 and later is to set the Seed
property of the AutoNumber column using ADOX.