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.
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.
In the Source Data
section, click a column by which you want the records sorted, and then drag it to the Order By
section.
Repeat this for each additional column that you want to include in the sort order.
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.
Click OK
.