Autonumber

[CMB]

I am looking for a way to autonumber an existing numeric field that I am
converting from an existing database. The number is in sequence and I would
like to be able to keep the same numbers if possible.

Thank you.

 

[John Vinson]

I am looking for a way to autonumber an existing numeric field that I am
converting from an existing database. The number is in sequence and I would
like to be able to keep the same numbers if possible.

Thank you.

Create a new, empty table by copying and pasting this table, design
mode only. Change the number ID field to an Autonumber field.

Then run an Append query appending all of the fields into the new
database. If you Append a number value into an autonumber field, the
autonumbering feature won't kick in - it will just copy the number
that's there.

New records after you've copied the data will start out at one more
than the highest existing value (gaps will not fill in).

John W. Vinson[MVP]