Query Property Sheet Order By Tab

This tab lists the columns in the ORDER BY clause, which control the way in which the data retrieved by the query will be sorted.

You can add or delete columns as appropriate, and reorder the columns in the list using the arrows at the bottom of the tab. Any changes you make will propagate to the query's SQL tab and to the SQL Query tab of the parent view.

  1. Click in the first empty row in the list.
  2. In the Column column, select a column from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  3. In the Sort Direction column, select either ASC or DESC.
Parent topic: Working with View Queries