3305 Main Street Ste 019 Vancouver, WA 98663

Sort Order

In this step of the wizard you can identify how the results from your query should be sorted by identifying one or more columns to sort.

Add Sort Displays the Available Sort Columns window allowing you to select a column to sort by.
Remove Sort Removes the selected column from the sort order.
Sort Ascending Changes the sort direction of the selected column to sort values in ascending order.
Sort Descending Changes the sort direction of the selected column to sort values in descending order.
Move Column Up Moves the selected column higher in the list of sort columns.
Move Column Down Moves the selected column lower in the list of sort columns.

You can also affect the sort order by right-clicking on a column heading in the preview pane and using the sorting options that appear in the pop-up menu. Changes that you make to the sort order using this method will be reflected on this step.

Note - This step constructs the ORDER BY clause in the underlying SQL statement.