If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sequentally numbering records in a report
I would like to number the records in a report so that the first record is
number 1, and each subsequent record is incremented by 1. That is, 1, 2, 3, etc. I know how to run a loop in VBA, but I don't know how to use either the Format or Print event of the report's Detail section to get the current value of the incrementing variable into the detail section of the report. What's the best way to sequentially number the records in a report? Thanks in advance, Paul |
#2
|
|||
|
|||
sequentally numbering records in a report
Paul wrote:
I would like to number the records in a report so that the first record is number 1, and each subsequent record is incremented by 1. That is, 1, 2, 3, etc. I know how to run a loop in VBA, but I don't know how to use either the Format or Print event of the report's Detail section to get the current value of the incrementing variable into the detail section of the report. What's the best way to sequentially number the records in a report? No code needed. Just use a text box with the expression =1 and set it's RunningSum property to Over All -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
sequentally numbering records in a report
Ooo, nice.
Thanks, Marsh. P "Marshall Barton" wrote in message news Paul wrote: I would like to number the records in a report so that the first record is number 1, and each subsequent record is incremented by 1. That is, 1, 2, 3, etc. I know how to run a loop in VBA, but I don't know how to use either the Format or Print event of the report's Detail section to get the current value of the incrementing variable into the detail section of the report. What's the best way to sequentially number the records in a report? No code needed. Just use a text box with the expression =1 and set it's RunningSum property to Over All -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|