How to auto number starting with # other than 1

[T]

I've checked in the help screen and have gotten some
direction, but I can't seem to make it happen. Does
anyone have any suggestions

 

[Lynn Trapp]

To start at 1001, run the following query and then delete the inserted
record from your table.

INSERT INTO YourTable(YourAutoNumberField)
VALUES(1000);

 

[Douglas J. Steele]

Just to piggyback on Lynn's suggestion.

It may not be sufficient to simply insert a row with a value for the
Autonumber field. You'll also need to supply values for any fields that are
non-optional.