Order By Tab, Query and View Designers

See Also

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

If the Cross Tabulate option is selected in the Fields tab, the order field list is created automatically.

For more information, see the ORDER BY clause in the SELECT - SQL command.

Tab Options

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.