Order By Tab, Query and View Designers

Specifies fields, aggregate functions such as SUM Command or COUNT Command, or other expressions used to set the order of records retrieved in the query.

You can select fields from the Order By tab that are not included in the SELECT list.

• Selected Output
  Lists the selected fields and expressions that will appear in the query results.
• Ordering Criteria
  Specifies the fields and expressions used in the query's sort order. The arrow that appears to the left of each field specifies an ascending (up) or descending (down) sort. A mover box appears to the left of the arrow for changing the order of the fields.

Order Options

• Ascending
  Sets the selected item in the Ordering Criteria box to sort in ascending order.
• Descending
  Sets the selected item in the Ordering Criteria box to sort in descending order.
• Add
  Adds the selected item in the Selected Output box to the Ordering Criteria box.
• Remove
  Removes the selected item from the Ordering Criteria box.

See Also

COUNT Command | Fields Tab, Query and View Designers | Filter Tab, Query and View Designers | Group By Tab, Query and View Designers | SELECT - SQL Command | SUM Command | Update Criteria Tab, View Designer