report printing - staple after section

[sbradley0]

Hopefully someone can help! I've been googling my brains out on this
and found little info.

I have a report, rather large, that I want to have staple after each
group. I saw somewhere in my journeys that someone suggested writing
code to print for each group separately. This report is basically a
financial report for our consulants' accounts, the groups I want to
have separated are the consulants' id numbers (tkinit). Unfortunately
my I'm much better with vba in Excel than in Access. Is there
anything that anyone knows about that can point me in the right
direction?

Thanks!

 

[RBear3]

Just sort and group by consultant ID and make sure to include a group
footer. In the group footer, include a page feed. It is one of the items
in your toolbox when you are in design mode for the report.

 

[sbradley0]

Just sort and group by consultant ID and make sure to include a group
footer.  In the group footer, include a page feed.  It is one of the items
in your toolbox when you are in design mode for the report.

--
Hope that helps!

RBear3
.








- Show quoted text -

The page feed I already knew about, but what I'm trying to do is
staple after each group, which led me to thinking of some vba code
that would print each iteration of tkinit separately... which I don't
know how to do.