Line numbers in report

[mufasa]

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]

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)