save snapshot to multiple files

[kimchavis]

I have a report that is grouped by branch. We have 116 branches, and at anytime data can be populated for 1 or all of the branches. Each branch needs their own report. I have a macro that runs all of my daily reports and outputs them to a snapshot and I really dont want to have to add all 116 branches as a report to it. I was hoping there was a way to run the report as it stands and then break up each group systematically to its own file. Any ideas on this? Im using Access 2003.

Thank you!!

 

[padinka]

Take a look at excel pivot tables your access database as the source data. You could add your branches as a "Page" section and it would allow you to report view each branch separately or all the branches together. To update the report you merely have to open it and 'Refresh' the pivot table.

Trisha
padinka@yahoo.com