Combine simple query results.

[Carrie]

This is the query I have so far.

SELECT [Tbl - TS Created SR's].[Created Day], [Tbl - TS Created SR's].[Functional Sub Area], [Tbl - TS Created SR's].Queue, Count([Tbl - TS Created SR's].[SR #]) AS [Software Update Count]
FROM [Tbl - TS Created SR's]
GROUP BY [Tbl - TS Created SR's].[Created Day], [Tbl - TS Created SR's].[Functional Sub Area], [Tbl - TS Created SR's].Queue
HAVING ((([Tbl - TS Created SR's].[Created Day])>=[Start Date] And ([Tbl - TS Created SR's].[Created Day])<=[End Date]) AND (([Tbl - TS Created SR's].[Functional Sub Area]) Like "Health Network" Or ([Tbl - TS Created SR's].[Functional Sub Area]) Like "MENDS") AND (([Tbl - TS Created SR's].Queue) Like "Software Updates" Or ([Tbl - TS Created SR's].Queue) Like "Software Update"));


When it reports I get two records of data. One for MENDS and one for Health Network and because Software update goes with MENDS and Software updates goes with Health Network.

I want to combine the totals. So if there were 6 in one and 7 in the other I would get one total that says Software update is 13.

Is this possible?

 

[Andrew Fergus]

Hi Carrie

I think it is the "Group By's" that is causing the problem.

Try pasting this SQL into a new query and see if it returns what you want :

SELECT Count([Tbl - TS Created SR's].[SR #]) AS [Software Update Count]
FROM [Tbl - TS Created SR's]
WHERE ((([Tbl - TS Created SR's].[Created Day])>=[Start Date] And ([Tbl - TS Created SR's].[Created Day])<=[End Date]) AND (([Tbl - TS Created SR's].[Functional Sub Area]) ="Health Network" Or ([Tbl - TS Created SR's].[Functional Sub Area])="MENDS") AND (([Tbl - TS Created SR's].Queue) Like "Software Update*"));

HTH, Andrew