User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-43
4
In Advanced query options, select Order by.
The ORDER BY Clauses dialog box appears.
5
Enter values for the Sort key number and Sort order fields for the appropriate
Fields.
To specify January as the primary sort field and display results in ascending order:
a
In Fields, select January.
b
For Sort key number, enter 1.
c
For Sort order, select Ascending.
d
Click Apply.
The Current clauses area now displays:
January ASC
6
To specify February as the second sort field and display results in ascending order:
a
In Fields, select February.
b
For Sort key number, enter 2.
c
For Sort order, select Ascending.
d
Click Apply.
The Current clauses area now displays: