Autonumber question

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

In Access 97, how can I set up a field using Autonumber to
start at a specific number and increment from there? For
example, in a new table, If I set up the Employee_ID field
as an Autonumber type and us Increment for New Values, how
can I have it start at say 1000, instead of 1?

Thanks!
 
1. Run the following Query.

INSERT INTO YourTable (YourAutoNumberField)
VALUES (999);

2. Delete that record.

When you start creating records the first one you enter should have 1000 as
the ID number.
 
Back
Top