Good morning,
I have a report in Access that I would like to export. Both as a pdf and as a word document. However it is 138 pages of reports and I want to know how I can export them into individual pages and not one pdf of 138 pages.
I know I can create queries for each page then a macro to send them to their destination but I am hoping there is some kind of macro or something I can run that will separate them without having to make all the queries.
What will separate them is a code. We are a religious organization so I want each parish code to have its own report.
I am not a macro/VB expert so if you could explain in detail that would be great.
Thanks