Autonumber

#1

Is there a way for Access 2000 to start an autonumber at anything other
than zero? Any help is appreciated. Thanks.

Joe

#2

Create an Autonumber column such as myAutoNumber, then run a query like

INSERT INTO MyTable (myAutoNumber) VALUES (555)

to start Autonumber at 555.

Good luck,
Pavel

Joseph Frazer wrote:

Quote:

Is there a way for Access 2000 to start an autonumber at anything other
than zero? Any help is appreciated. Thanks.

Joe

#3

Pavel Romashkin wrote:

Quote:

Create an Autonumber column such as myAutoNumber, then run a query like

INSERT INTO MyTable (myAutoNumber) VALUES (555)

to start Autonumber at 555.

That worked. Thanks.

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

Autonumber

comp.databases.ms-access comp.databases.ms-access

Autonumber - 08-05-2003 , 10:18 AM

Re: Autonumber - 08-05-2003 , 10:52 AM

Re: Autonumber - 08-05-2003 , 11:09 AM