sequentally numbering records in a report

[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

 

[Marshall Barton]

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

 

[Paul]

Ooo, nice.

Thanks, Marsh.

P

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