Add an incremental field to an existing table

[Duncs]

I have a table with data in it, whihc now needs to have a unique ID
added to each record. The ID must start at 2000000 and increment by 1
for each record.

Can I achieve this, and if so how?

Many TIA

Duncs

 

[Duncs]

Ken,

Sorry for the unreasonable delay in replying to you. I tried your
suggestion and it works a treat for me. It also gives me a bit more
scope to do some otheer things with the data.

Cheers

Duncs

I'd suggest first adding an autonumber column, and a long integer number
column to the table.  The autonumber will be  filled automatically.  Check
that it starts with 1 and increments by 1, and if so execute an update query,
updating the long integer number column to:

[YourAutonumberColumn]+1999999

You can then delete the autonumber column from the table and make the long
integer number column its primary key, or otherwise index it uniquely andset
its Required property to True (Yes).  To increment the long integer number
column for subsequent new records Roger Carlson has simple methods for
generating custom 'autonumbers' in either a single or multi-user environment
at:

http://www.rogersaccesslibrary.com/forum/topic395.html

Or my slightly more complex method at:

http://community.netscape.com/n/pfx/forum.aspx?nav=libraryMessages&ts....

allows the next number to be generated to be reseeded at any time.

Ken Sheridan
Stafford, England

I have a table with data in it, whihc now needs to have a unique ID
added to each record.  The ID must start at 2000000 and increment by 1
for each record.

Can I achieve this, and if so how?

Many TIA

Duncs