Access 2007
Sorting Records
Sorting on Text Values
When Access 2007 sorts on a text value, it offers the two options described in the table below:
| Sort Option | Also Called | Description |
| A to Z | Ascending | Values closest to A are displayed first |
| Z to A | Descending | Values closest to Z are displayed first |
To sort based on a text value
To sort based on a text value:
- Click the drop-down arrow at the top of the field you wish to sort.
Sorting A to Z - When the menu appears, select either the Sort A to Z or the Sort Z to A option.
- With A to Z, the records will be sorted based on the chosen field's value with the value closest to A at the top of the table, as seen below.
Records Sorted A to Z on Category - With Z to A, the records will be sorted the using the chosen field's value with the value closest to Z at the top of the table.
The sort command section in the Sort group on the Ribbon is another way to begin the sort.
- With A to Z, the records will be sorted based on the chosen field's value with the value closest to A at the top of the table, as seen below.
