Microsoft Office Tutorials and References
In Depth Information
Session 7.2 Quick Check
1. What is a detail report? a summary report?
2. The property prints a group header on a page only if there is
enough room on the page to print the first detail record for the group; otherwise, the
group header prints at the top of the next page.
3. A(n) section appears by itself at the top of a page, and the detail
lines for the section appear on the previous page.
4. The property, when set to Yes, expands a text box vertically to
fit the field value when a report is printed, previewed, or viewed in Layout and
5. Why might you want to hide duplicate values in a report?
Adding the Date to a Report
According to Lucia’s design, the rptInvoicesByItem report includes the date in the Page
Header section, along with the report title, the page number, the column heading labels,
and a line under the labels.
Placing the Report Title, Date, and Page Number
in the Page Header Section
When you use the Report tool or the Report Wizard to create a report, the report title is dis-
played in the Report Header section and the page number is displayed in the Page Footer
section. However, the date (and time) is displayed in the Report Header section when you
use the Report tool and in the Page Footer section when you use the Report Wizard. Because
you should create reports that display controls in consistent positions, you have to move the
date control for reports created by the Report tool or by the Report Wizard so the date is
displayed in the same section for all reports.
Although company standards vary, a common report standard places the report title, date,
and page number on the same line in the Page Header section. Using one line saves vertical
space in the report compared to placing some controls in the Page Header section and oth-
ers in the Page Footer section. Placing the report title in the Page Header section, instead of
in the Report Header section, allows users to identify the report title on any page without
having to turn to the first page.
To add the date to a report, you can click the Date & Time button in the Controls
group on the Ribbon, and Access will insert the Date function in a text box without an
attached label at the right edge of the Report Header section. The Date function returns
the current date. The format of the Date function is =Date() . The equal sign (=) indicates
that what follows it is an expression; Date is the name of the function; and the empty set
of parentheses indicates a function rather than simple text.