Sorting Records

In Access XP sorting records may seem confusing at first. This free lesson offers step-by-step instructions.

Removing a sort

After a sort is performed, you will be given the option to save the sort or to remove it to allow the records to return to the way they were ordered before you applied the sort.

To remove the sort order:

  • Choose RecordsRemove Filter/Sort from the menu bar.

    Remove Filter/Sort option on Records Menu

    The records revert to their ordering before the sort was applied.

If you add new records to a table that has been sorted, any new records are automatically saved.