Count By Month

[Guest]

I have a query that I'm trying to count by month. Right now I have it
counting by days but now I want to count that up by months. How would I
modify my query to do so?

SELECT qryVariance.FLSHIPDATE, Count(qryVariance.VARIANCE) AS CountOfVARIANCE
FROM qryVariance
GROUP BY qryVariance.FLSHIPDATE;

 

[Guest]

format([FLSHIPDATE], "mmm")

will give the date in month: "Jan", "Feb", .....

 

[Guest]

Perfect! Thanks!

format([FLSHIPDATE], "mmm")

will give the date in month: "Jan", "Feb", .....

--
www.ae911truth.org

I have a query that I'm trying to count by month. Right now I have it
counting by days but now I want to count that up by months. How would I
modify my query to do so?

SELECT qryVariance.FLSHIPDATE, Count(qryVariance.VARIANCE) AS CountOfVARIANCE
FROM qryVariance
GROUP BY qryVariance.FLSHIPDATE;