To group information on a report, you will do the
following:
Determine the items to appear in the
group. Determine which table or tables contain the information you
want to appear in the group. List the fields that you want to
appear in the group, and the fields that will used to determine the
members of each group.
Sort the report data in an order
appropriate for creating the group. You need to sort the data for
the report so that the report items appear in an order that allows
them to be grouped.
Create additional headers for each group
category. Additional headers for the report will contain the
information that describes each group.
Create additional footers to summarize the
group information. Additional footers for the report can perform
summary actions such as totaling or subtotaling for each
group.