The "ORDER BY Clause" option is used to order columns in a view. To add an ORDER BY to your view, the following methods are available:
•select the "ORDER BY Clause" button on the Query Builder Toolbar
•select "Query" > "ORDER BY Clause" from the menu bar
•right click on the desired table/view displayed in the list of Tables in Use
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.
If you wish to change the sort order for a selected column, right click on the column to display the speed menu for changing the order.
You can also remove an unwanted sort on a column by selecting the column from the "Current Selection" list, and pressing the "Remove" button.