Microsoft Access 4B: Reports: Headers / Footers / Functions

• Headers appear at the top of a grouping in a report

Note: this list of student's classes is grouped by student number (instead of having the student number appear beside each class...avoids redundancy).

• The section that has the label for StudentNumber and the corresponding field is the "header" for this group
• Headers are created in the Design View by clicking on the More button

Footers:

• Footers are sections that appear at the bottom of each grouped section as shown:

• Footers are created the same way as headers

Then selecting a footer section as shown

Functions:

• Functions can be placed on a report and include the following:
  • date that report is created
  • page of report
  • count of number of records in total or in a section
  • average of records in total or in a section
  • and many others
  Example

Note the above function will display the date at the bottom of a report page =Now()

• You can change the size, color and format (e.g. mm/dd/year to another date format etc.) by double-clicking on the function

Microsoft Access will put some functions in automatically when you use the Report Wizard and select various options, or you can use the text box (under the Design tab) to create your own

Note: the function below is more complicated

="Page "&[Page]&" of " & [Pages]

Note anything in quotation marks e.g "Page " will be actually printed out combined with an actual number used in the square bracket function [Page]

The square bracket function [Pages] refers to the total number of pages in a report

In report view the above function would appear as follows in a 3 page report:

Page 1 of 3 pages

• Because page and date functions are so common you can also insert them using buttons under the Design tab

This website and its content is copyright of FreeOfficeTutorials.com © FreeOfficeTutorials.com 2011. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is strictly prohibited.