OurTown2000 Query Handbook - To Modify a Query

<-Back (To Modify a Query-Picking Group and Summary Fields) Table of Contents Next (To Modify a Query-Selecting the Type of Output)->

 

Sorting the Output Records

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)->

OurTown2000 Query Handbook - To Modify a Query