You can order your query by the contents of a data column or by an expression. The Query Designer allows you to specify the sort types ascending and descending.
You can also order the query results by more than one column or expression and specify the sort order for each. For example, if you are querying an employee table, you can order the results by department (sort order = 1) and within each department by last name (sort order = 2).
Note You cannot sort by the contents of a memo or binary (BLOB) column.
To order query results
If you don’t want the columns or expressions to be part of the query results, remove them as output columns.
–or–
In the Diagram pane, right-click the column to sort by and then choose Sort Ascending or Sort Descending from the shortcut menu. You can select multiple columns before right-clicking them. If you use this method, the columns are sorted in the order you select them.