Query Order Results

The Query Designer form Order By section is for sorting the query results. Adding sort orders is not required.

Example: If the browse list or report lists staff members, add the staff member’s last name field in the Selected Sort Field box to list staff names alphabetically by last name.

1. From the Tools menu, select the Queries... option.

   The Queries form is displayed.
   

2. Select the module and record area, and either create a new query, or modify an existing query.

   Information on creating or modifying a query is available in Create New Query and Modify Query.

3. Verify that Report is selected for Query Type(s) for the query.

4. Click the Pivot Table tab.

   The fields listed in Available Cross-Tab Fields are the selected fields from the Fields section.

   • Properties

   • Tables

   • Fields

   • Join

   • Filter

   • Order By

   • Group By

   • Having

   • Pivot Table

5. Add a field to the sort order.

   1. Highlight the field name in the left box then double-click or press .

      You can select multiple fields to the sort order.

   2. Press to sort records in ascending order (A to Z) based on the values in the highlighted field.

      Fields in the sort do not have to be in the results table.

   3. Press to sort records in descending order (Z to A) based on the values in the highlighted fields.

      Fields in the sort do not have to be in the results table.

 

Related Topics: 

• Query Group