Microsoft Office Tutorials and References
In Depth Information
Creating and Managing Report Sections
To display the word Page as well as the number, type
= “Page “ & Page
Adding the date and time
If you want to include the current date or time on your report, follow the
same steps as in the preceding section, but type the following expression in
the Control Source property of another text box:
= Now()
The Now() function returns both the date and time (11/25/12 1:55:48
PM). If you want to print only the current date, format the box as a date by
setting the Format property accordingly. (In the property sheet for the text
box, click the Format tab and set the Format property to one of the date
formats, all of which omit the time.)
Controlling which pages get page headers and footers
You can choose whether the Page Header and Footer sections print on all
pages, all but the Report Header page (so that your cover page isn’t
numbered), all but the Report Footer page, or all but the Report Header and
Footer pages.
To change the Page Header and Footer sections’ properties, follow these steps:
1. With the report open in Design view, display the property sheet for
the report.
2. Click the Format tab of the property sheet.
3. Set the Page Header and Page Footer properties.
Your options are All Pages, Not With Rpt Hdr, Not With Rpt
Ftr, and Not With Rpt Hdr/Ftr.
Displaying the first value of a field in the Page Header section to make a
telephone-book–style header is easy. Just create a text box in the Page Header
section that displays the field. When you print the report, the text box shows
the value for the first record on the page. You can also print the value of the
last record on the page in the Page Footer section.
Grouping your records
To create grouping sections, you tell Access to group the records in your
report by the value of one or more fields. For each field, you get a Grouping
Header and Footer section for that field (as listed in Table 1-2, earlier
in this chapter). The report shown in Figure 1-8, earlier in this chapter,
lists customer orders, with records grouped by customer (identified by
ContactID) and within customer by order (OrderID). If you choose to add
both a header and footer section for each group, you end up with ContactID
Search JabSto ::




Custom Search