Free E-Books

2. Click the Add a group button in the Group, Sort, and Total area.
3. Select Category from the field list, and Access adds Group on Category with A on
top of the Group, Sort, and Total area.
Access adds Category Header and Category Footer sections to the report??™s design as soon
as you select the Category field for grouping. The Category Header section appears
between the Page Header and Detail sections. If you define a group footer, it appears
below the Detail section. If a report has multiple groupings, each subsequent group
becomes the one closest to the Detail section. The groups defined first are farthest from
the Detail section.
The Group Properties pane (displayed at the bottom of the Sorting and Grouping box) contains
these properties:
n Group Header: Yes creates a group header. No removes the group header.
NOTE
332
Access Building Blocks Part I
n Group Footer: Yes creates a group footer. No removes the group footer.
n Group On: Specifies how you want the values grouped.


Pages:
738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762