Part I: Access Building Blocks
148
FIGURE 4.18
An ascending sort has been specified for the LastName and FirstName fields.
Outer join
Query results Products with no category
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, but they’re
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 4.18, the LastName field is sorted first, and then the FirstName
field.
Figure 4.19 shows the results of the query shown in Figure 4.18. Notice that the data is sorted by
LastName, and then by FirstName. This is why Ann Bond appears before John Bond, and John
Jones appears before Kevin Jones in the query’s data.
