Selects the columns by which to sort the rows in a dataset in a query.

To open this window, open Query Designer, select an empty row in the designer, and then on the View menu, choose Properties. In the Properties window, locate the OrderBy property, and then choose the AssistEdit button in the Value field. In the OrderBy window, choose the Up Arrow button in the Column field. For more information about how to open Query Designer, see Query Designer.

By default, rows in a dataset of query are not sorted. You can sort the rows in the dataset in ascending or descending order by one or more selected columns in the query. For information about how to sort a dataset in a query, see How to: Sort a Query Dataset in Ascending or Descending Order.


Field Description

Column Name

Specifies the name of the column.

Column Caption

Specifies the caption of the column.