Multiple Reports

[Ray]

Hi,

I need to print 4 sets of reports for 18 parties from my
database. Is there a way to use a macro to change the
query to print the reports to PDF automatically? The only
alternative I can see is 72 queries and related reports...
Any ideas would be appreciated.

Many thanks.
Ray

 

[SA]

Ray:

Rather than changing the query, normally what you'd do is to filter the
report using a WHERE clause when it is run, e.g. "[CustomerID] = 1232"

If you want to automate output of the pdf files you might look at our PDF
and Mail library for Access, which you can use with any number of PDF
printer drivers, and if you have the PDF Pro or Pro Plus edition, then
combine individual report PDF files into one final merged PDF file that you
could mail to your repective parties.

The library supports specifying a WHERE clause for your report(s) when they
are run so that you can output a specific report to a PDF file unique to the
specific party.

You'll find it on our web.