Print a report as a merge...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DebraH - 04 Jan 2006 00:13 GMT

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?

Signature

Debra H

Reply to this Message

Allen Browne - 04 Jan 2006 02:29 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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?

Reply to this Message