Adding an ORDER BY Clause

To add an ORDER BY clause to your query, you need to open the ORDER BY dialog window (figure 1) by either clicking the

icon, right-clicking the table in the Tables in Use panel to display the speed menu from which you choose Order Clause, or by clicking Query>Order Clause from the Menu Bar across the top.

(figure 1)

Once the ORDER BY dialog appears, you can select the table from the list of selected tables in the Table drop-down list. After you pick the desired table, select a column from the associated list, choose whether the sort order is Ascending or Descending, and press the Add button. Repeat this for all columns you wish to have ordered in the query.

After selecting the columns and their desired sort order, you can rearrange them by selecting a column in the Current Selection list, and using the Move Up or Move Down button respectively.

You can also remove an unwanted sort on a column by selecting the column from the Current Selection list, and pressing the Remove button.