Create Multiple Files from 1 query.

[turkee]

Hello. I have an Access2010 front end with a SQL backend. I have a report that a user runs where user can enter Customer Number and begin and end date. They now want to run that same report for multiple customers of their choosing and ouput 1 pdf file for each customer.
Is that even possible? If so, what would the code be?

 

[Samantha]

Follow the directions here it works.

http://crissysmarteningup.blogspot.com/

 

[turkee]

Thanks Samantha, but I didn't see anything about exporting to multiple pdf files each with it's own unique name. Example:
If I input customer numbers 1350,1351,1352,et al i want to run a report for each customer and export the results to files 1350.pdf,1351.pdf,1352.pdf etc. All while clicking 1 button on a menu. Since there are multiple salesmen running multiple reports, it's not feasible to run 1 report per customer. Any ideas?