Please Help - Auto Number

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

HOW To: make an auto number to be the number wanted. Explain by default in
MS-Access when selecting a (AutoNumber) Field from a table Number Starts
from 1 to 999 Etc and What I am Looking for to make it start the Number I
want for instance 100 instead of 1.

I know how to do this in SQL Server Database Table
but I have not luck in Access.

TIA
 
Append a dummy record to the table with a long integer that is one less than
the number you want to start at:

INSERT INTO tblWhatever ( AutonumberIDfield)
SELECT 99 AS Expr1;

Make sure you also add any required fields for which you have not set
default values. After you add the first real record, delete the dummy
record.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin gave you the procedure, so I will be the first one to tell you
don't bother.

Auto numbers have only one use. To provide a unique number for each
record. That is the way they were programmed. They were never designed to
provide consecutive numbers and for any number of reasons may not give you
the expected results.

If you really want consecutive numbers, you need to do it
programmatically.
 
Back
Top