Increment AutoID staring with a number other then 1

[Sharon123 via AccessMonster.com]

Hi,
Does anyone know how I can add an auto number to my existing table that would
start with a number of then 1. For example 50, 51, 52 etc..
Thanks in advance for your help

 

[Golfinray]

Try this. Start a new query in design view. Make it a make-table query. Go to
sql view and type:
alter table tablename
add column id counter (1001,50)
or wherever you want to start. Run the query. It should add that column to
your table.

 

[Jeff Boyce]

Why? If you are using an Access "Autonumber" field, they are designed to
provide a unique row identifier. That's it. They really aren't fit for
human consumption, so it probably doesn't matter what number they have.

Why does it matter to you?

Regards

Jeff Boyce
Microsoft Office/Access MVP