Specify the Query Sort Order

Use the Order pane in the Select Accounts window to specify the sort order for the query results. 

To specify the query sort order

1. With the Select Accounts window open, in the Data Selection pane, click the plus sign (+) next to a folder to expand it.

2. Click the data item to use to sort the query results and drag and drop it into the Order pane.

Note: If the query window has a Select Columns pane, you can sort by aggregate data. Drag the aggregated column from the Select Columns pane and drop it into the Order pane. For more information about aggregating data, see Assign an Aggregate Function to a Query Column.

3. Drag and drop more data items as necessary.

Related Topics

Query Order

Queries