Print Access report summaries without redesigning the report

With Access, there's no need to reinvent the wheel when it comes to creating and printing report summaries. Mary Ann Richardson explains how to select the information you need (and hide what you don't need) in Access report summaries.

You manager would like a printout of the summary data in all of the reports in your database as collateral for her end-of-year department evaluation report. You need to print out all 10 reports without the detail data, and you need to have it ready within the hour. Fortunately, you don't need to create new reports — you can hide the detail section so the detailed data does not appear in the printout. Follow these steps:

  1. In the Database window, click Reports under Objects.
  2. Click the name of the report, and then click the Design button.
  3. Right-click within a blank area of the Detail section.
  4. Select Properties.
  5. Under the Format tab, click in the Visible property box and select No.

When you print the reports, all sections but the detail sections will print. You can use the Visible property to hide any section of the report. For example, to print a detailed listing of the Customer Orders report without the summary information, you would change the Visible property of the header and footer sections to No and leave the Detail section in the Visible property to Yes.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent 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

Free Newsletters, In your Inbox