Auto Number to start at a specified number

R

Rick B

Please note, this is asked and answered all the time. In the future, I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the "groups"
options, and enter a search string starting with the following...

microsoft.public.access autonumber start specific


This has been addressed at least twice that I can recall in the last two
days.

You should also find that autonumbers should not need to start at a specific
point because you should not be using them for anything meaningful, only to
create a unique key field.
 
S

Steve Schapel

Diane,

Open a blank query in design view, and enter 21999 in the Field row of
the first column of the query design grid. Make it an Append Query
(select Append from the Query menu), and nominate your table. In the
Append To row of the grid, enter the name of the Autonumber field. The
SQL of the query will look something like this....
INSERT INTO [YourTable] ( YourAutoNumberField )
SELECT 555 AS Expr1;

Run the query (click the toolbar button with the red [!] icon). Close
the query, open the table, and selete this record just added. After
that, the next record added will have 22000 in the autonumber field.
 
Top