Groups of 10 on Report

  • Thread starter Thread starter Chip
  • Start date Start date
C

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
 
Chip said:
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.
Click to expand...


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
 
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
 
Back
Top