Autonumber question

[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!

 

[Lynn Trapp]

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.