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 text values

When Access 2007 sorts on a text value, it offers the two options described in the table below:

Sort OptionAlso CalledDescription
A to ZAscendingValues closest to A are displayed first
Z to ADescendingValues closest to Z are displayed first

To sort based on a text value: