Adding the sorting criteria

Access the Query Builder page. See Accessing the Query Builder.

Click the Sorting tab.

Select a table from the left side of the Query Builder. If required, 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.

Select Ascending (sorts from A to Z) or Descending (sorts from Z to A) from the Direction list.

Repeat steps 3-5 to add a secondary sorting field. Every subsequent sort is applied as a sublevel of the sort preceding it.

Note: Numeric calculated fields cannot be sorted.