Sorting Data

To sort in ascending order by a single field, simply click anywhere in that field and choose Sort Up from the Sort menu.

Sorting1

The data will be sorted in ascending order

Sorting2

Sorting Multiple Fields

It is often necessary to sort by more than one field at a time. For example, you may need to sort both first and
last names, or cities and states. After you have sorted the database once, you can use the Sort Up Within (or
Sort Down Within) commands to sort by additional fields. For example to sort by city and state, first sort by the state.

CityStateSort1

Now click on the city field and choose Sort Up Within. The cities will be sorted within each state, while the states remain sorted alphabetically.

CityStateSort2

To learn more about sorting see Chapter 8 of Panorama Essentials or the Panorama Handbook.