Group by year and count 1

[din2005]

Hi i have this query where i would like to show all private patients and group them by year for e.g

year patients
2006 15
2005 26
etc


so far i've got this

SELECT PATIENTS.Hospital_no, PATIENTS.firstname, PATIENTS.Surname, TREATMENT.TREATDATE, TREATMENT.PrivatePatient
FROM PATIENTS LEFT JOIN TREATMENT ON PATIENTS.Hospital_no = TREATMENT.HOSP_NO
GROUP BY PATIENTS.Hospital_no, PATIENTS.firstname, PATIENTS.Surname, TREATMENT.TREATDATE, TREATMENT.PrivatePatient
HAVING (((TREATMENT.PrivatePatient)=True))
ORDER BY TREATMENT.TREATDATE DESC;


anyway to adapt this so it shows every year how many patients treated

 

[PHV]

SELECT Year(TREATDATE) AS [Year], Count(*) AS Patients
FROM TREATMENT
WHERE PrivatePatient = True
GROUP BY Year(TREATDATE)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886