Order By

Sorts rows in a dataset from a query in ascending or descending order by a column or columns.

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


You cannot sort on the same column more than once.


Field Description
Column The name of the query column as specified by its Name Property.
Direction The direction of the sort. You can choose Ascending or Descending.