Print a report as a merge...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is grouped on user id - with multiple pages for each
user. I want to run each user id as a separate report (so that I can have the
copier staple the pages).

Is there a way with in access to accomplish this?
 
You will need to OpenReport once for each user.

To achieve that, you will need to use VBA code.
OpenRecordset() to get a list of users.
Loop through the list.
In the loop, OpenReport with a WhereCondition that limits the output to just
that one user.
 
Back
Top