Summary Reports

Creating a summary report in Access is delightfully simple (though not very intuitive). All you have to do is create a grouped report with sums, counts, or other aggregate functions in a group footer and then set the Visible property of the Detail section of the report to No. You may need to do some reformatting, such as removing a group header or changing the formatting of a label or textbox control in the group footer as well. If the standard report was formatted for landscape printing, you may be able to change it to portrait for the summary report. Figure 6.27 shows a summary report based on the tabular Orders report.

Figure 6.27