Sorting Records

When working in Access sort data to make it easier to work with, including text-based and numerical data in your Access database.

Sorting on numerical values

Access 2007 also offers two options when sorting based on a numerical value. These options are described in the table below:

Sort OptionAlso CalledDescription
Smallest to LargestAscendingValues closest to 1 are displayed first
Largest to SmallestDescendingValues farthest from 1 are displayed first

To sort based on a numerical value:

Clear All SortsClear All Sorts Command