#### Sorting records

In a typical customer list report, customer names are listed alphabetically. In this example, you will sort the customer names alphabetically within each region.

###### To sort records

1. While on the `Preview` tab, click `Sort Order` on the Standard toolbar.

   The Record Sort Order dialog box appears.

   The Report Fields list box displays all fields currently on your report. You can choose to sort based on any of these fields.

   The Sort Fields list box displays the fields that are already sorted in the report. Since the region field has already been sorted, the sorting you are about to do will be within each region, and not for the entire report.

2. Highlight the `Customer Name` field and click `Add`. Notice that the `Customer Name` field now appears in the `Sort Fields` list box.
3. Select `Ascending` for the Sort Direction and click `OK`.

   The report should now look similar to the following:

Notice that the records within each group are in alphabetic order.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com