Adding the Sorting Criteria

Open Query Builder.

Click the Sorting tab.

Select a table from the left side of the Query Builder. If necessary, click the plus sign to expand the list of tables.

Select a field from the right side of the Query Builder. This field displays all fields that belong to the selected table.

Double-click the field to add it to the grid at the bottom of the window.

From the Direction list, select Ascending (sorts from A to Z) or Descending (sorts from Z to A).

To add a secondary sorting field, repeat steps 3-5. Every subsequent sort will be applied as a sublevel of the sort preceding it.

Note: Numeric calculated fields cannot be sorted.