View Full Version : Line numbers in report


mufasa
05-27-2008, 12:23 AM
I have straight forward report with 10 record per page. I want to put a line number 1 to 10 on each report. How do I accomplish this.

At the ,moment the first column is a text base column and I have changed the control source to =1 and I made the running sum overall and group but this goes on and I want it to reset after it reaches 10.

Thx

ErikSnoek
05-27-2008, 12:45 AM
Looking at this purely in a mathematical way, this could do the job.
At the textbox with the running SUM, use this as control source:
=((yourrunningsumnumber/10)-Int(yourrunningsumnumber/10))*10
or shorter:
=yourrunningsumnumber Mod 10
That way, 115 will be shown as 5 and 8768 as 8 (for example):p