Report footers typically display grand totals or other statistics
(such as averages or percentages) for the entire report. The report footer for the Products Summary
report uses the expression = Sum with each of the numeric fields to sum the amounts.
When there is a report footer, the Page Footer section is printed after the report footer.
The Report Writer in Access is a two-pass report writer, capable of preprocessing all records to calculate
the totals (such as percentages) needed for statistical reporting. This capability enables you
to create expressions that calculate percentages as Access processes those records that require foreknowledge
of the grand total.
Creating a Report from Scratch
Fundamental to all reports is the concept that a report is another way to view the records in one or
more tables. It is important to understand that a report is bound to either a single table or a query
that brings together data from one or more tables. When you create a report, you must select
NOTE
TIP
317
Presenting Data with Access Reports 9
which fields from the query or table you want to see in your report.
Pages:
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734