Changing the Sort Order

When viewing a recordset, you often want to display the data in a sorted order. You may want to sort the recordset to make it easier to analyze the data (for example, to look at all the tblProducts sorted by category).

Sorting places the records in alphabetical or numeric order. The sort order can be ascending (0 to 9 and A to Z) or descending (9 to 0 and Z to A). You can sort on a single field or multiple fields.

You input sorting directions in the Sort row in the QBE grid. To specify a sort order on a particular field (such as LastName), perform these steps:

Figure 36-16 shows the QBE grid with ascending sorts specified for the LastName and FirstName fields. Notice that the LastName field is still showing the sort options available. Also notice that the word Ascending is being selected in the field’s Sort: cell.

The left-to-right order in which fields appear in the QBE grid is important when sorting on more than one field. Not only do the fields appear in the datasheet in left-to-right order, they are sorted in the same order (this is known as sort order precedence). The leftmost field containing sort criteria is sorted first, the first field to the right containing sort criteria is sorted next, and so on. In the example shown in Figure 36-16, the LastName field is sorted first, and then the FirstName field.

Figure 36-17 shows the results of the query shown in Figure 36-16. Notice that the data is sorted by the values in the LastName column, and the values in the FirstName column are sorted within each name in the LastName column. This is why Ann Bond appears before John Bond in the query’s data.