Autonumber

[Guest]

I inherited data base where each record has a manually assigned number. I
would like to make this same field an Autonumber but retain the originally
assigned numbers. There are no duplicates in the existing numbers. Any
ideas?

wal50

 

[Guest]

I should have added that this number is used for identification (the reason
for wanting to retain existing numbers). Gaps are not an issue nor is being
in sequence.

 

[Douglas J. Steele]

Create a new table that's identical to the existing table, except that the
ID field is an Autonumber.

Create an Append query to take all of the data from the existing table and
append it to the new table above.

Use the new table from now all: the next ID number generated will be one
more than the highest number you inserted.

 

[Guest]

Thanks Doug. It worked like a charm. I must have done something wrong
though since I ended up with the duplicate records but they were easily
identifiable and deleted.

wal50