848 Chapter 28 Display Data
- To reverse the sort order by using a different method, on the Home tab, in the
Sort & Filter group, click the Descending button.
The sort order reverses. The records for customers living in Washington (WA) are
now at the top of the list, and the arrow at the right end of the field name is pointing
downward.
In both sorts, the region was sorted alphabetically, but the City field was left in a
seemingly random order. Suppose you want to see the records arranged by city
within each region. You can do this by sorting the City field and then sorting the
Region field. - Click the arrow to the right of the City field name, and then click Sort A to Z.
Access sorts the records alphabetically by city.- To finish the process, right-click anywhere in the Region column, and then click
Sort A to Z.
The two fields are now sorted so that the cities are listed in ascending order within
each region.
Both the City and Region field names have upward-pointing arrows.- On the Home tab, in the Sort & Filter group, click the Remove Sort button to
clear the sort from both fields.