Groups of 10 on Report

[Chip]

I am trying to build a report that will give my listed output data in groups
of 10. So that each group of 10 will be on printed different page.

Is there any way of doing this in ACCESS?

AS ALWAYS THANKS IN ADVANCE!!!!
Chip

 

[Marshall Barton]

I am trying to build a report that will give my listed output data in groups
of 10. So that each group of 10 will be on printed different page.

If your "listed output" is the detail records, then you can
use an arrangement like:

Add a Text box (named txtLinNum) to the detail section. Set
its control source expression to =1 and Running Sum to Over
All.

Then add a Page Break control (named pgEject) at the very
bottom of the detail section.

Finally, add a line of code to the detail section's Format
event procedure:
Me.pgEject.Visible = (txtLinNum Mod 10) = 0

 

[Clifford Bass]

Hi Chip,

Does your detail shrink or grow from record to record? If not, just
set the bottom margin to a height that limits the rows to 10. If so, of if
there is something else going on, please describe your report in more detail.

Clifford Bass