Database Reference
In-Depth Information
To correct this problem, include the RepNum field in the design grid twice, as shown in Figure 2-27.
50
RepNum ield
included twice
Because RepNum is to
the left of CustomerName,
RepNum will be the
major sort key
Ascending
sort order speciied
for RepNum and
CustomerName ields
First RepNum ield
will not appear in the
query results
FIGURE 2-27
Correct query design to sort by RepNum and then by CustomerName
The correct query design shows the Ascending sort order selected for the first RepNum field, which will
not appear in the query results because the check mark was removed from its Show check box. Because
this RepNum field is to the left of the minor sort key (CustomerName), RepNum is the major sort key. The
second RepNum field in the design grid will display the rep numbers in the query results in the desired
position, as shown in Figure 2-28.
