Creating a Single Filter for 11 Reports

[fishlips20]

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.

 

[fishlips20]

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.

 

[giacomo]

you might find this helpful: Using parameters with queries and reports

hth,
Giacomo