Query that has multiple information pulled, counts, totals, and does quartly

[rbellucci]

ok so this is what I got so far

SELECT DISTINCTROW Format$(IRTSI.Incident_date,'\Qq yyyy') AS [Date By Quarter], irtsi.eir_num, count(irtsi.eir_num) AS Total
FROM IRTSI
GROUP BY Format$(IRTSI.Incident_date,'\Qq yyyy'), irtsi.eir_num, Year(Irtsi.Incident_date)*4+DatePart('q',Irtsi.Inc ident_date)-1
HAVING (((Format$(Irtsi.Incident_date,'\Qq yyyy'))=[Which Quarter (Example: Q1 2012)]) And ((count(irtsi.eir_num))>0));




This works btw, but I need it to pull more data at once, I have 4 things I need the same information for and i'm unable to get it to pull the data and total it. Makes it easier for the end user when creating reports. Any advice?

[rbellucci]

So i've been trying to build off the 5 different Querys that pull quartly data as a single query to get away from it promptying the user 5 times to give input. I was able to get it show data, but the data isn't totalling correctly.