February 19, 2009
Let Access add your name to a report
- Date: December 9th, 2008
- Author: Mary Ann Richardson
It’s useful to include some basic information in Access report footers, such as the name of the person who prepared the report. Here’s a simple way to prompt for the user’s name and insert it in the page footer.
Since a report is just a snapshot of a database at a certain date and time, generic cialis review it is helpful to include that information in the report printout. In addition to a time and date stamp, it’s also nice to have the preparer add his or her name to the end each report page. Follow these steps:
- Open the report in Design view.
Click the Text Box control tool and then click and drag in the Page footer section of the report.
Select the text in the Label control, type Prepared by:, and format it as desired.
Click in the text box and enter the formula below, as shown in Figure A:
=[What is your name?]
When you run the report, you’ll see the dialog box shown in Figure B.
After the preparer enters his/her name, the report will output with a page footer like the one shown in Figure C.