ACC: How to Print Line Number for Each Record/Group on ReportLast reviewed: October 24, 1997Article ID: Q98790 |
The information in this article applies to:
SUMMARYModerate: Requires basic macro, coding, and interoperability skills. You can add a text box control that prints a sequential number for each record to the detail section of a report. This number can be reset so that a separate set of numbers is printed for each group of records. This article explains these procedures by modifying a report in the sample database Northwind.mdb (or NWIND.MDB in Microsoft Access 2.0 or earlier). NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95 version 7.0) and RptSmp97.exe (for Microsoft Access 97). For information about how to obtain these sample files, please see the following articles in the Microsoft Knowledge Base:
ARTICLE-ID: Q145777 TITLE : ACC95: Microsoft Access Sample Reports Available on MSL ARTICLE-ID: Q175072 TITLE : ACC97: Microsoft Access 97 Sample Reports Available on MSL MORE INFORMATIONIf you want to print an incremental counter for each record in a report group, add an unbound text box control to the detail section of the report. To begin the sequence with the number 1, set the ControlSource property to =1, and then set the RunningSum property to Over Group. To print an incremental counter for each record in a report group, follow these steps:
Add the following text box control before the Category Name control in the Category Name Header section: Object: Text Box -------------------- Name: MyLineNumber2 ControlSource: =1 RunningSum: Over AllRepeat step 3 above. Note that each individual record now prints a unique sequential number.
REFERENCESFor more information about printing an incremental counter for each record in a report, search for "Calculated controls, reports," and then "Number each detail record in a report" using the Microsoft Access 97 Help Index.
|
Additional query words: reports sequential line
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |