Auto numbering

  • Thread starter Thread starter Laurena
  • Start date Start date
L

Laurena

Auto numbering starts at 1 but I want it to start at
11890. How do I change the auto numbering format????
 
in Access help see topic "Change the starting value of an incrementing
AutoNumber field"

regards,
CTaHk0
 
The simplest approach is to import a record containing the value 11889.
Details:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

In Access 2000 and later, it is also possible to set the Seed of the
Autonumber field. Use the ADOX library to set the "Seed" property of the
Column in the Table in the Catalog.
 
You have been directed to the tricks, but keep in mind that auto numbers
are not consecutive numbers, it is designed to provide unique numbers.
Expecting it to keep number consecutive is likely to prove a disappointment.
There are other ways to do consecutive numbers that work.
 
Back
Top