Specifies a sort order that is applied to the database table records displayed in the Data View window.
Right-click a column header in the Data View window and choose Sort.
You can select a combination of up to five columns to apply to the sort order.
The following options are displayed.
Specifies the primary column to apply to the sort operation. The data from this column is sorted first, and then the data from any additional Then By columns that are specified is sorted.
Applies an ascending sort order to the selected column. The column data is ordered with the smallest value at the beginning of the Data View record set and the largest value at the end of the record set.
Applies a descending sort order to the selected column. The column data is ordered with the largest value at the beginning of the Data View record set and the smallest value at the end of the record set.
Specifies an additional column to apply to the sort operation.
Clears all columns that are specified for the current sort order so that you can specify a new sort order.