Question on how to write multiple queries

Novaember

Registered User.
Local time
Today, 03:07
Joined
Nov 3, 2009
Messages
33
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. :rolleyes:
 
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. :rolleyes:

You can run all of the queries, and then pull the queries into one query the report is based on in your "show table" window.
 
hrmmm well that worked with about 10 items but after I added in all of them it said Query is too Complex!
maybe i can break it up into a couple queries with some queries in each and try to get the report wizard to link all those into 1 report. I don't think that will work either actually.
 

Users who are viewing this thread

Back
Top Bottom