Use a group footer to print summary information for a group. This is where you place the controls that make up the main body of the report. For more information about creating group headers and footers, see the section Add grouping, sorting, or totals.Īppears once for every row in the record source. You can have multiple group header sections on a report, depending on how many grouping levels you have added. When you place a calculated control that uses the Sum aggregate function in the group header, the sum is for the current group. For example, in a report that is grouped by product, use the group header to print the product name. Use the group header to print the group name. Use a page header to repeat the report title on every page.Īt the beginning of each new group of records. The report header is printed before the page header. When you place a calculated control that uses the Sum aggregate function in the report header, the sum calculated is for the entire report. Use the report header for information that might normally appear on a cover page, such as a logo, a title, or a date. How the section is displayed when printed The following list is a summary of the section types and their uses: For example, the section in which you choose to place a calculated control determines how Access calculates the results. Understanding how each section works can helps you create better reports. The design of a report is divided into sections that you can view in the Design view. While it is possible to create “unbound” reports that do not display data, but for the purposes of this article, we’ll assume that a report is bound to a data source such as a table or query. Provide details about individual records. Overview of reports in Access What can you do with a report?Ī report is a database object that comes in handy when you want to present the information in your database for any of the following uses: Highlight data with conditional formatting Note: The information in this article is intended for use only with Access desktop databases.