How do you set a range for Auto Number in Access 2002?

[Guest]

I am new to Access, and recently took an online course. This helped a bit,
but I need more advanced help. I would like to set an Auto Number field to
start counting at "US06001" up to "US06999", and then restart at "US16001".
Is this possible, and how? Thanks for any help.

 

[Ken Snell [MVP]]

An autonumber field contains only numbers...no letters. And you cannot
"control" it the way you wish... or perhaps I should say, if you were to try
to do it, you'd find that you are not going to achieve the desired results.

What you want to achieve is done by using two fields: a Text field to hold
the "US" text, and a Long Integer field to hold the numbers. Then you would
run code or a macro that increments the values as you wish when you add new
records.

 

[gls858]

I am new to Access, and recently took an online course. This helped a bit,
but I need more advanced help. I would like to set an Auto Number field to
start counting at "US06001" up to "US06999", and then restart at "US16001".
Is this possible, and how? Thanks for any help.

Check this link. Lots of good info at the site.
Take a look at Commandment #7

http://www.mvps.org/access/tencommandments.htm

gls858