Autonumber - sorting criteria

[Judy]

Someone in my office reset the autonumber field to a regular number field. Now we are trying to redo the autonumber without changing the members' id numbers. We have filled in all blank id numbers so there are no skipped numbers. I thought that I might be able to add another autonumber column and have it numbered based on the sorting of the original id column. However, it keeps sorting the new autonumbered id alphabetically. Can anyone help me renumber based on the original id column?

 

[Douglas J. Steele]

Do you have relationships based on what was formerly the AutoNumber field?
If not, you can rename the existing table, create a new table exactly the
same as the old table, but with the member's id number as an AutoNumber, not
a Long Integer, then use an Append query to take the data from the old table
into the new table. (Append queries can set the value of AutoNumber fields:
no other query can)


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Someone in my office reset the autonumber field to a regular number field.

Now we are trying to redo the autonumber without changing the members' id
numbers. We have filled in all blank id numbers so there are no skipped
numbers. I thought that I might be able to add another autonumber column and
have it numbered based on the sorting of the original id column. However, it
keeps sorting the new autonumbered id alphabetically. Can anyone help me
renumber based on the original id column?