G
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;
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;