Auto Number Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have over 100 entries into my table and wanted to assign an auto number now
by date. I sorted my table by date, added a column RecordNumber and made it
an Auto Number. When I view the table, Number 1 does not match up with the
first date listed. It takes it out of order. How do I fix that?
 
The primary purpose of an autonumber is to assign a unique identifier to a
row in a table. A secondary use is to order a recordset in data entry
sequence (assuming that the autonumber is assigned sequentially). If you
added the autonumber after there was already data in the table, the record
order may seem strange but I would recommend against changing it.

If you insist and there aren't any related tables, create a new table with
the same definition. Create a query that sorts the existing data into
sequence by date. Change this query to an append query and run it to append
data to the new table. When everything is working properly, delete the
original table and rename the new table.
 
Back
Top