Selected Table(s) |
Displays the table being processed in generating a query. |
Available Fields |
Displays the fields of the table displayed in the Table dialog. Note: If there are joined tables selected, the table's alias appears in front of each field's name, to distinguish fields from different tables.
|
OrderBy Field |
Enter the field by which you want your query results sorted. Double-clicking a field in Available Fields copies it into the OrderBy Field text box. |
Descending |
When on, selects sorting in descending order. When off (the default setting), selects sorting in ascending order. |
Clear |
Deletes the contents of the OrderBy Field text box. |
Apply |
Copies the ORDER BY clause generated in the OrderBy tab page into the SQL Select Statement text box. |