In Access, I created a parameter query using specific criteria in several fields. The parameter prompts for one more piece of information. The report that calls the query will print data based on the parameter and all other fields publish in two columns. It works well if you want to print one or two reports, but ultimately I need to march through each parameterized group and create a report based on multiple results.
At first I was successful at creating a report not based on the parameter prompt and in the report properties, I indicated Grp Keep Together as Per Page. Now I get one document which does start each group on a new page, which is what I would expect to get based on that setup.
However, instead of one document, I need to create separate documents printed out for each group. I've seen a few things that may lead to creating a module but I'm not that familiar with writing loop statements. I think I may need to use For Each and While or something, but I'm not sure. And, in the end, rather than sending the jobs to a printer, I need to print each separately to PDF.
Any assistance is appreciated! Thank you
At first I was successful at creating a report not based on the parameter prompt and in the report properties, I indicated Grp Keep Together as Per Page. Now I get one document which does start each group on a new page, which is what I would expect to get based on that setup.
However, instead of one document, I need to create separate documents printed out for each group. I've seen a few things that may lead to creating a module but I'm not that familiar with writing loop statements. I think I may need to use For Each and While or something, but I'm not sure. And, in the end, rather than sending the jobs to a printer, I need to print each separately to PDF.
Any assistance is appreciated! Thank you
