25 items on each page

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I need to make a "batch sheet" for account numbers. Each
batch sheet is limited to 25 account numbers. However the
query the report pulls from could have 1 - ??? account
numbers. Designing the report is easy enough - a simple
list. How do I limit each page to only listing no more
than 25 account numbers?

Any help is appreciated
FRank
 
I need to make a "batch sheet" for account numbers. Each
batch sheet is limited to 25 account numbers. However the
query the report pulls from could have 1 - ??? account
numbers. Designing the report is easy enough - a simple
list. How do I limit each page to only listing no more
than 25 account numbers?

Any help is appreciated
FRank
Click to expand...

Add an unbound control to the Detail section.
Set it's Control Source to
=1
Set it's Running Sum property to Over All
Name this control
CountUp
You can make it Not Visible if you wish.

Add a Page Break to the Detail section.

Code the Detail format event:
PageBreakName.Visible = CountUp Mod 25 = 0
 
Back
Top