Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen. Image of Sorting screen.

Sorting a Query

A query is sorted in the Results window.

  • The default order for sorting data in the Results window is in ascending order.
  • You can sort the query on up to 3 fields.

To sort a query:

  1. Click the Sorting button to open the Sorting dialog box.

    Click the picture for more information.

    Image of Sorting screen.

  2. Click the Sort By down-arrow to reveal the available sort by fields.

    If you select Descending, the sort order of the Sort By field displays the highest value first.

  3. Use the And check box to add or remove fields from the sort.
    • Click the Apply button to apply the sort to the query and return to the result window.
    • Click the Reset button to reset the query to the original default sort.
    • Click the Cancel button to cancel the sort and return to the result window.