I would like to see a total for each month of the year in this same format, would that be a subquery? I'm not sure how to setup the syntax.
I want to see how many canid's are in each month as the months go by
SELECT Attrit.division, Count(Attrit.canid) AS CountOfcanid
FROM Attrit
where Attrit.[Hire Date]<=#2/1/2007#
GROUP BY Attrit.division
;
I want to see how many canid's are in each month as the months go by
SELECT Attrit.division, Count(Attrit.canid) AS CountOfcanid
FROM Attrit
where Attrit.[Hire Date]<=#2/1/2007#
GROUP BY Attrit.division
;