I am trying to write a script that will group by year based on a date:
SELECT Count(qlkpApplicantWaitingListMain.ApplicationID) AS TotalCount, qlkpApplicantWaitingListMain.[Approval Date]
FROM qlkpApplicantWaitingListMain
GROUP BY qlkpApplicantWaitingListMain.Status, qlkpApplicantWaitingListMain.[Approval Date]
ORDER BY qlkpApplicantWaitingListMain.[Approval Date];
I am trying to get to:
Total Count Year
34 2006
45 2007
.
.
.
This needs to be based on the column qlkpApplicantWaitingListMain.[Approval Date]
Any advice?
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD