Sorting Retrieved Data by Column Values

To sort data using the SQL Wizard:

  1. Run the SQL Wizard and on the Select Operation dialog box, click SQL Select.
  2. Proceed in the SQL Wizard until you reach the Select Columns To Sort By dialog box.
  1. In the Select Columns To Sort By dialog box, select a column from the list of available columns and click Add. Repeat this action for each column to be sorted or, to sort all the columns in the list, click All >>.
  2. To re-order the sequence of selected columns, select a column in the Selected Columns list and click the Up or Down arrow to move the column up or down in the list. The first column in the list is the primary sort column.
  3. To sort a column in descending order, select it in the Selected Columns list and choose In Descending Order from the drop-down list box.
  4. Click Next to continue creating the query.

- Or -

Click Back to return to the previous screen in the SQL Wizard.

- Or -

Click Finish if the query is done.

NOTE: To remove a column from the query, select it from the Selected Columns list and click Remove All to remove all the columns in the query.

See Also