Adding an AutoNumber

[StacyStacy]

I have an existing table that has a date entered field. The outcome of this task is to add the autonumber field in the sorted table according to the date entered field. The earliest date should have #1 as the autoNumber, not 906.

So far I have not been successful ... Please help.
Thanks,

 

[StacyStacy]

Thanks Pat. I used a "Around the World" method which worked as well:

I inserted a field entitled, "RecordID" and made the data type to "auto number". I then indexed the field, "Rec" to Yes(Duplicates OK). Next, I exported the table to an excel spreadsheet. In Excel, I filled in the RecordID by using a "Fill Series" feature in Excel to number the records 1 thru 1060 starting with the oldest "Rec" date, which should be the first record in that table.

By doing this, the table is now sorted on the field, "Rec" (Date Notification Was Received) where the first record is the earliest date and is marked #1 for the "RecordID", which is the autonumber.

Once this was completed, I imported the file back into Access.