Is there a way to re-index an AutoNumber field in an access 2003 table? Basically I have this table called "Events" and it uses AutoNumber type for one of its fields for the records in the table. The AutoNumber skips around due to records being added/deleted.
The problem I am faced with is my form shows/sorts the records by AutoNumber from table Events and so now all the data is mixed up. I want to be able to show the records on the form sorted by date bot record AutoNumber ID.