Show TOC

Procedure documentationSorting Records by More Than One Set of Values

Procedure

Use this procedure to sort records first by the values in one column, and then within those values by the values in one or more additional columns. You can also specify whether records are sorted in ascending or descending order for each column that you include in the sort order.

  1. On the selection window listing records that you want to sort, click Sort. The Set Sort Order window appears. The Source Data section at the left of the window lists the columns that you can include in the sort order. The Order By section on the right lists the current sort order that is in effect.

  2. In the Source Data section, click a column by which you want the records sorted, and then drag it to the Order By section.

  3. Repeat this for each additional column that you want to include in the sort order.

  4. In the Order By section, do any or all of the following:

    • To adjust the sequence of the sort order, click the first field by which you want to sort and drag it to the top of the list, and if necessary, click and drag additional columns below the first column until the columns are in the order that you want.

    • To sort any column in descending order, click the corresponding Ascending check box to remove the checkmark.

    • To remove a column from the sort order, click and drag it back to the Source Data section.

  5. Click OK.