Access 2007: autonumber

#1

I am building an inventory database and need to generate a numbes that
autogenerates. the problem is tht there are already some items that
have numbers and I need the new numbers to start after they left off.
How do I tell Access to start the autonumber at a certain number, i.e.
601, 602, 603... instead of 001,002 ...

Also, is it possible to prefix the numbers with characters, i.e.
GOV601?

Thanks in advance for any suggestions!!

#2

Dad wrote:

Quote:

I am building an inventory database and need to generate a numbes that
autogenerates. the problem is tht there are already some items that
have numbers and I need the new numbers to start after they left off.
How do I tell Access to start the autonumber at a certain number, i.e.
601, 602, 603... instead of 001,002 ...

Also, is it possible to prefix the numbers with characters, i.e.
GOV601?

Thanks in advance for any suggestions!!

Poczytaj o INSERT INTO ... :O)

#3

Dad wrote:

Quote:

I am building an inventory database and need to generate a numbes that
autogenerates. the problem is tht there are already some items that
have numbers and I need the new numbers to start after they left off.
How do I tell Access to start the autonumber at a certain number, i.e.
601, 602, 603... instead of 001,002 ...

Also, is it possible to prefix the numbers with characters, i.e.
GOV601?

Thanks in advance for any suggestions!!

Take a look at INSERT INTO ... :O)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 2007: autonumber

comp.database.ms-access comp.database.ms-access

Access 2007: autonumber - 02-20-2009 , 11:46 PM

Re: Access 2007: autonumber - 04-09-2009 , 08:43 AM

Re: Access 2007: autonumber - 04-09-2009 , 08:45 AM