Export (0) Print
Expand All
Expand Minimize

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.

Hh166358.note(en-us,NAV.70).gifNote
You cannot sort on the same column more than once.

Fields

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.

Show:
© 2015 Microsoft