Macro to loop through Access report with different criteria, and output in pdf
Posted on 2011-04-27
I have built a Report based on certain fields in a Query in Access. The fields in the Report are Region, Country, EmployeeID, and some data about each employee. I am looking to tailor the report for various recipients and would use different criteria on the Query if I had to do this manually. But I am trying to have a report for each Region that would contain all Countries of the Region, and also a report for each Country. I have the CutePDF writer program and I would like to ouput each version of the report as a pdf document with the ability to save each one with a name that I specify as it is produced. Thank you.