O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

11.1. Introduction to Reports

Reports in Access are designed to provide a view of data in a table or query whose initial purpose is to be printed. That said, Access 2007 takes reports to the next level and provides interactivity that was not available in previous versions.

11.1.1. How Reports Are Structured

Several different components make up a report. Perhaps the most important are the various sections and group levels that are defined in a report.

Sections are used to display data and other controls such as labels or combo boxes. The following table describes the types of sections in order.

Section TypeDescription
Report HeaderTypically displays report titles or similar information. Prints once at the top of the report.
Page HeaderPrints at the top of each page.
Group HeaderTypically displays unique data for a group or aggregate data such as a Sum or Average. Prints at the top of each group level. This section can be repeated when the data in a group spans multiple pages. (You can have a maximum of 10 groups in a report.)
DetailDisplays records in a report.
Group FooterDisplays summary information for a group level. Prints at the bottom of each group level.
Page FooterPrints at the bottom of each page. Often used to display page numbers.
Report FooterPrints once at the end of the report.

One thing that sets reports apart from forms is the capability to group data. Grouping lets you create aggregates or to view related data in a hierarchical fashion using group levels. Let's say you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required