Hi
I have many queries I want to run off of a group of data.
For each query I'm going to select a UserName, Year, Month, and ResultType. Those 4 things will all be constant for every query.
Then I wand to do about 100 different 'views' of the same data.
I want a query that counts all Defect Opportunities, Defects, and then total defects by type (there are 12 different types), process (8 of these), action generated (9 of these).
I also want to run all of these queries by Year and then again by Month.
When finished I want to generate 1 report by UserName that gives them all this data.
I know what the queries need to say. But if I have each one separate I can't generate 1 report. Report Wizard won't let me. So I'm not sure what to do. Maybe create a report that just runs a macro that runs all the queries? No clue.
Any help is greately appreciated.
I have many queries I want to run off of a group of data.
For each query I'm going to select a UserName, Year, Month, and ResultType. Those 4 things will all be constant for every query.
Then I wand to do about 100 different 'views' of the same data.
I want a query that counts all Defect Opportunities, Defects, and then total defects by type (there are 12 different types), process (8 of these), action generated (9 of these).
I also want to run all of these queries by Year and then again by Month.
When finished I want to generate 1 report by UserName that gives them all this data.
I know what the queries need to say. But if I have each one separate I can't generate 1 report. Report Wizard won't let me. So I'm not sure what to do. Maybe create a report that just runs a macro that runs all the queries? No clue.
Any help is greately appreciated.
