Getting to Know Microsoft Access, Part 8: Learning about Reports - More Ways to Customize Your Reports
(Page 4 of 4 )
Count summaries count the number of records in each group and then show those summaries wherever you want in your report. You can add a count summary to the footer of a report by opening the report in Design view and creating a text box control in the group footer. In the property sheet of the control type: =Count([Entry]).
A running total calculates the accumulated values in a group and resets the value to 0 for the next group, and then does the same thing to the following group. Simply add a running total by selecting the appropriate checkboxes when you create a calculated control. Set the Running Sum property to either Over Group or Over All.
Subreports are complete reports inserted into the main report. Use the Subform/Subreport control to create a subreport in the report design. When you click to create the Subreport, you will be given a series of dialog boxes from which to choose options for your subreport, such as the fields you wish to show in the subreport from your tables or queries.
You can create multiple column reports by first specifying a columnar layout in the Report Wizard. Then, using Page Setup, you can specify as many columns as you like.
Printing Mailing Labels and Envelopes is easy in Access. Since you can fit many labels on one page of printed paper you’ll design your labels in columnar layout. To get started, let’s use the Label Wizard. Just open the New Report dialog box and select Label Wizard. In the following dialog boxes you’re able to specify the Unite of Measure, the Label type, and the brand of label. You’ll also be able to select your font type, size, weight, and color. You can also specify underlining and italics. Finally you’ll need to move the fields to the prototype label, add spaces, punctuation, and other characters you need.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 13 
