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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
The next Grand Theft Auto title has been officially announced 0
Auto Number Starting Other Than ONE 1
changing start value in the auto number 4
Auto Number reset to 1 16
Number Reverts to Zero 5
Word 2007: Auto-numbering, how to set a start number other than 1 2
Auto Numbering in existing numbers 22

Back
Top