Grouped data is data that is sorted and
separated into meaningful groups. For example, a customer list may be sorted by
Postal Code or Region. In a sales report, a group might consist of all orders
placed by a particular customer or orders generated by a particular sales
representative.
Group and sort direction
When data is grouped, the following sort
and group direction options are available. Direction refers to the order in
which the values are displayed:
Ascending
Ascending order means smallest to
largest (1 to 9, A to Z, False to True). The program sorts the records in
ascending order and then begins a new group whenever the value changes.
Descending
Descending order means largest to
smallest (9 to 1, Z to A, True to False). The program sorts the records in
descending order and then begins a new group whenever the value changes.
Specified order
Specified order is an order that you
customize for your needs. The program places each record into the custom group
that you specify, leaving the records in each group in original order; or, it
sorts them in ascending or descending order, depending on your instructions.