Please Help - Auto Number

[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

 

[Arvin Meyer]

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