Adding the Sorting Criteria To add 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. Parent topic: Query Builder Sorting Related topics What is the Query Builder?
Adding the Sorting Criteria To add 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. Parent topic: Query Builder Sorting Related topics What is the Query Builder?