Print Report (2 copies each page)

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

Guest

I have a report that I print from a macro. I was printing the report twice
but I am getting complaints that the recipient wants two copies each page
together, 1,1,2,2,3,3, etc.

When I tried adding a table to the query with numbers 1 and 2, I got a
message "ambiguous outer joins".

Please help.
 
Beverly,

I would look at your printer properties. Some (not all)
printers will enable you to set an option like "collate"
on / off. Try playing with this option to achieve what you
want. In page setup you can specify a printer and
properties for your report.

HTH

Terry
 

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

Back
Top