How to auto number starting with # other than 1

  • Thread starter Thread starter T
  • Start date Start date
T

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
 
To start at 1001, run the following query and then delete the inserted
record from your table.

INSERT INTO YourTable(YourAutoNumberField)
VALUES(1000);
 
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.
 
Back
Top