babble324
asked on
Combining multiple queries
I run the following query on several tables.
Each table represents a different district/area; and I would like to combine the query results into one big query.
Sometimes I am trying to combine 2 query results, sometimes I combine 3 queries.
How do I go about combing such query results?
Thanks
Ps. this is done in MS Access.
SELECT DateSerial(Year([TicketDate]), Month([TicketDate]), 1) AS yyyymm, Count(CumulativeSumProblem.TicketNumber) AS CountOfTicketNumber,
(Select Count(*) From CumulativeSumProblem As CS Where
DateSerial(Year(CS.[TicketDate]), Month(CS.[TicketDate]), 1) <= DateSerial(Year(CumulativeSumProblem.[TicketDate]), Month(CumulativeSumProblem.[TicketDate]), 1) ) As CumulativeSum
FROM CumulativeSumProblem
GROUP BY DateSerial(Year([TicketDate]), Month([TicketDate]), 1);Each table represents a different district/area; and I would like to combine the query results into one big query.
Sometimes I am trying to combine 2 query results, sometimes I combine 3 queries.
How do I go about combing such query results?
Thanks
Ps. this is done in MS Access.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
"Yes sir" as in that's what you needed, or something else?
:)
:)
ASKER
That's what I needed. Thanks a lot!
ASKER
Actually, since I need this data for an MS graph, is there a way you can have the query results be as following:
Date RegionOne_Sums RegionTwo_Sums.
that way; the date column is a common factor.
Date RegionOne_Sums RegionTwo_Sums.
that way; the date column is a common factor.
ASKER