Sorting Multiple Records

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

Multiple sorting example

To sort by Student Last Name, Student First Name, and Phone, the columns must be adjacent. In this picture, the Phone column was just moved to its appropriate position

To sort by multiple fields, select all fields involved in the sort, and click the Ascending or Descending button on the toolbar.