| <-Back (To Modify a Query-Picking Group and Summary Fields) | Table of Contents | Next (To Modify a Query-Selecting the Type of Output)-> |
|
|
This dialog lets you determine how your results will be sorted. To select a sort field by mouse, double click on it. To select by keyboard, highlight it and press Enter. You may specify up to nine different sort fields. |
|
|
N/A |
This button is disabled because you specify sort fields one at a time. |
|
|
Removes all fields from the Fields to sort records by list. |
This allows you to clear all previous sort selections and display information in the order it appears in the database. |
|
|
Alternates a selected sort field between an ascending sort order and a descending sort order. (Sort is ascending unless you specify otherwise.) 1. Highlight a field in the Fields to sort records by list. 2. Press Sort to toggle between ascending and descending order. |
If you have specified descending order, then the DOWN indicator appears:
Note: If you have specified more than one sort field, changing the status of ascending or descending does not move fields to a different position in the Fields to sort records by list. (The first field in the list is sorted before the second and so on.) |
|
|
Saves your sort specifications and exits this dialog. |
You return to the Query Overview Dialog. |
|
|
Exits without saving changes. |
You return to the Query Overview Dialog. |
|
|
Displays descriptive help text. |
|
Note: You can change the order of fields in the sort list in the same way that you reorder output table fields (See Selecting Fields to Show in Query.)
| <-Back (To Modify a Query-Picking Group and Summary Fields) | Table of Contents | Next (To Modify a Query-Selecting the Type of Output)-> |