I am using Access 97. I created 1 large report that gives an agency's name as the form/report page header and a list of Names, SubAgency, and Email on the body/detail of the page.
I want to break up the large report into smaller reports based on each agency and I want create a file for each report.
Is there a procedure to generate these multi reports (such as a filter and using a loop to go thru all the different agencies)? I have very little VB experience. Any suggestions on how to procede?
I want to break up the large report into smaller reports based on each agency and I want create a file for each report.
Is there a procedure to generate these multi reports (such as a filter and using a loop to go thru all the different agencies)? I have very little VB experience. Any suggestions on how to procede?