Software

Use Access menus to add page numbers, dates, and times to your reports

In Access, you can use menus to add page numbers, dates, and times to your reports -- and Access provides menus so that you don't have to know the code for setting these controls. Here's how to add the details to your reports.

While the Report Wizard automatically adds page numbers to your Access report, it does not add a date and time stamp. And, if you create a report in Design view, you have to add the controls for the page numbers as well. Access provides menus so that you don't have to know the code for setting these controls.

For example, to add page numbers to the bottom of your report, follow these steps:

  1. Open your report in Design view.
  2. Go to Insert | Page Numbers.
  3. Click Page N Of M under Format.
  4. Click Bottom Of Page [Footer] under Position.
  5. Click the drop-down arrow under Alignment and select Center. Click OK.

If the first page of your report is a title page and you do not want the number to appear on that page, clear the Show Number On First Page check box before clicking OK in step 5.

The Page Numbers dialog box gives you a number of options for positioning the number in the header and footer. For example, if you are printing the report on both sides of the paper, you can select Inside or Outside in step 4.

To use the menus to insert a date and time stamp in your report's footer, follow these steps:

  1. Open your report in Design view.
  2. Go to Insert | Date And Time.
  3. Select the Date format you want to display under Include Date.
  4. Select the Time format you want to display under Include Time. Click OK.
  5. Drag the Time And Date fields to where you want to position them in the page footer section.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks