Creating multiple PDFs from 1 report

[ManipulatoRX]

Hi,
I have report that in general looks like this:
Store A something
Employee 1 something
Employee 2 something
Employee 1 something
Store B something
Employee 1 something
Employee 2 something
Employee 1 something
......
Store XYZ something
Employee 1 something
Employee 2 something
Employee 1 something



I would like to make as many PDF as there are stores.
1 PDF = 1 store.
How to make it?

[Micron]

And the pdf would contain what - all the same data but a pdf per store?
If not, consider using the OutputTo method of the DoCmd object. You could output the results of a query as a pdf, once per store by using a vba loop, but it wouldn't show aspects of the form design such as images or formatting. If you're wanting a view of the report but only with data pertinent to a store, I think you'll have to cycle opening/requerying or opening/closing the report, again in a loop. IIRC, simply filtering the report in a loop will provide a view per store OutputTo will output the entire report, sans filtering. I believe the same holds true if you had broken each store onto it's own page; i.e. you can't just output a page by itself.