Creating a Single Filter for 11 Reports

fishlips20

New Member
Joined
Jun 7, 2006
Messages
23
Hi everyone,
I currently have 11 reports which pull in information from 17 queries. These reports are perfect.

My problem is that there are 26 categories within each of the 11 reports. I need to replicate each of my 11 reports for each category. (i.e. report 1 --> 11 for category a, report 1-->11 for category b... etc.)

Is there any easy way to define one sub-category and have the 11 reports generate based on a user defined filter?

(please help me out, its been a while since i've used Access, and I'm not terribly well versed in VBA or macros).


Thanks for your help.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

fishlips20

New Member
Joined
Jun 7, 2006
Messages
23
FYI - for right now i'm using the "Brute Force" method to churn out this information

i.e. I'm copying each of the 17 queries, applying a filter on the specific column, then going into each of the 11 reports and redefining which table to pull from.

I know there has to be a better way. This feels like the stupid way of doing it.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,917
Messages
5,545,024
Members
410,647
Latest member
bernardazar
Top