Microsoft Access 2010 Bible

Part I: Access Building Blocks

342

Figure 9.23 shows rptProductSummary open in Design view. As you can see, the report is

divided into as many as seven sections. The group section displays data grouped by categories, so

you see the sections Category Header and Category Footer. Each of the other sections is also

named for the type of processing it performs.

FIGURE 9.23

rptProductSummary in Design view

Group header Detail section Page header

Page footer Report footer Group footer

You can place any type of text or text-box controls in any section, but Access processes the data

one record at a time. It also takes certain actions (based on the values of the group fields or current

section of the page being processed) to make the bands or sections active. The example in Figure

9.20 is typical of a report with multiple sections. As you learned, each section in the report has a

different purpose and different triggers.

Note
Page and report headers and footers are added as pairs. To add one without the other, resize the section you
don’t want to a height of 0 or set its Visible property to No.

Caution
If you remove a header or footer section, you also lose the controls in those sections.