Database Reference
In-Depth Information
Because
CustomerName
is to the left of RepNum,
CustomerName is the
major sort key
49
Ascending sort
order specified for
CustomerName and
RepNum fields
FIGURE 2-25
Incorrect query design to sort by RepNum and then by CustomerName
In Figure 2-25, the CustomerName field is to the left of the RepNum field in the design grid. With this
order, CustomerName is the major sort key, so the data is sorted by customer name first, and not by sales rep
number, as shown in Figure 2-26. If two customers had the same name, the data for these customers would
be further sorted by sales rep number because RepNum is the minor sort key.
Data incorrectly
sorted first by
CustomerName
Data sorted
second by
RepNum
FIGURE 2-26
Query results
