To add an ORDER BY clause to your query, click the Columns tab in the lower pane of the Query Wizard and right-click the Sort row of the column that you wish to sort, in this case CustID (figure 1). Then, choose either Ascending, Descending, or No Sort from the speed-menu list.

image37
(figure 1)


For details on ORDER BY clauses, see Commands: ORDER BY.