re-number rows in a report 3

[ouradmin]

I have a report that needs the rows numbered 1-10. On each page the rows are numbered 1-10. The report will be multiple pages. How do I get the report to number the rows and then reset the numbering on the subsequent pages?

 

[genomon]

On each page the rows are numbered 1-10

What are "rows" on your report? What is incrementing this number?

Knowledge is knowing a tomato is a fruit; Wisdom is not putting it in a fruit salad.

 

[ouradmin]

the detail of the report is reporting selected records from one of my tables. This is a government form that it needs to be reported on and they only want 10 records to show on each page. they need to be numbered from 1 to 10 and then start at 1 again on each of the subsequent pages.

 

[genomon]

What code or control is numbering them 1 to 10?

Knowledge is knowing a tomato is a fruit; Wisdom is not putting it in a fruit salad.

 

[ouradmin]

Right now I have a text box with a control of =1 and running sum set to overall. All of my records are in one group so I can't reset it using the overgroup option.

 

[dhookom]

Hide your existing text box and add another. Assuming your current text box is named txtRunSum, the new text box would have a control source of:

=[txtRunSum] Mod 10+IIf([txtRunSum] Mod 10=0,10,0)

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[genomon]

Can you add a different unbound text box to display line numbers? You could place a counter in the detail print event, populate the text box, and reset the counter in the report page event....

Knowledge is knowing a tomato is a fruit; Wisdom is not putting it in a fruit salad.

 

[ouradmin]

THANK YOU THANK YOU THANK YOU!!!!!!

Now I can get this monkey off my back.

 

[genomon]

Dang! As usual, Duane comes up with the "right" (and elegant) method. I hereby bestoweth a coveted star...

Knowledge is knowing a tomato is a fruit; Wisdom is not putting it in a fruit salad.