Sorting Multiple Records

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

Multi-field sorting example

The Student table is now sorted by Last Name, First Name, and Phone

Important PointYou can't perform multi-field sorts in Columnar or Tabular Form view.

To remove the sort order:

  • Choose Recordslesson actionRemove Filter/Sort from the menu bar.
  • If you add new records to a table that has been sorted, any new records are automatically saved.