Sorting Data

It is often useful to sort data alphabetically or numerically when you have retrieved data into Excel. This allows you to find data quickly by placing it into a meaningful order.

To organize the data in the order you want it to appear on the worksheet, you must define a sort. There are two ways to sort data:

  • If you used an index to define the data selection criteria, the data appears in the worksheet in the same order that the fields appear in the index.

  • If you didn't use an index, or if you want to override the sort order defined in the index, use the Sort tab to determine the order for the data.

The sort options in the Query Wizard work exactly like they do in Excel.

Example

Suppose you want to list the customers per location, in ascending alphabetical order according to their names and their amount due. To do this, select LOCATION , then CUSTOMER and use Ascending order.