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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing sections as seperate documents 2
Mail Merge Reports 1
Reports and Date Increments 2
Report - Don't print the page footer on the last page 6
report printing - staple after section 2
Group Totals and Grand Totals on each page 3
Printing Reports Question 2
Mail Merge with a many-to-one report/query 1

Back
Top