Export Access Report into Multiple Reports

[Guest]

Is there a way to export one Access report into multiple reports based on
detail section breaks? I have one big report for multiple city agencies that
I'd like to export into individual agency reports (i.e. so the Police
department doesn't have to look at a Health Department report and 70 other
Agency reports).

 

[Guest]

Kristina. The way you could make this work is by grouping your main report
(let us say by department) and the detail would only show for that specific
department. By setting the new page property for the Group header to before
you would start the report for each department on a new page.
I think that is what you wanted.
Hope this helps.
Fons

 

[Guest]

Hi Fons!
I already have all the grouping and new page settings in place. The issue
is that when I export to Microsoft Word it exports as one big report (100
pages). I'd like to actually get 100 seperate document files divided up by
where my page breaks currently are (after the detail section).

 

[Guest]

Now I understand. The only way I would approach that is to use a macro, but
it probably also can be done with VB. You could create a macro to run the
report with the specific filter and than step through it for all the separate
clients.
Maybe you wan to try it that way.
Fons

 

[Guest]

Thanks for your post Fons. Unfortunately I am new to the whole VB thing.
Has anyone done this before or even know what code I would begin to use for
such a task?