Change the initial number for AutoNumber to begin with

J

Jennifer

Can someone explain how I change my autonumber's beginning
number? I don't want 1, I want 400,000. I tried doing it
through Access help (with my program) and it didn't work!

I created a new table, Table1, with same field name that I
want to change (Invoice#)and added 399999 as a long
integer. Then I created a query with Invoice# field from
Table1, dragged Invoive# from top of query to Invoice#
field in list below, datasheet, run, design. After this I
understood I was supposed to delete Table1 and after this
I'm lost...
Thanks in advance for the help!
 
S

StCyrM

Hi Jennifer

The following procedure will do it for you.

Best regards
Maurice


By design, Microsoft Access always numbers AutoNumber fields beginning
with the number 1. You cannot edit an AutoNumber field or change its
starting value.

However, you can force Microsoft Access to number an AutoNumber field with
a number you choose by following these general steps:

- Copy the design of the original table in which you want to set the
starting AutoNumber value to a new table.


- Change the AutoNumber field in the new table to a Number field with a
FieldSize property of Long Integer.

- Add a record to the new table, and set the Number field to a value that
is one less than the starting number you want for your original table.
For example, if you want the AutoNumber field to start at 100, type 99
in the Number field of the new table.

- Use an append query to add a this new record to your original table.
This action forces Microsoft Access to number any new AutoNumber
fields with your number plus 1.
 

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

Top