sequentally numbering records in a report

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
Paul said:
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?
Click to expand...


No code needed. Just use a text box with the expression =1
and set it's RunningSum property to Over All
 
Back
Top