The code below is the query .
what im trying to do is to get all the personnelNumbers that occur greater than or equal to 4.
Help would be apprecated .Thanks Ritz
SELECT Count(tblSicknessEpisode.PersonnelNumber) AS CountOfPersonnelNumber, tblSicknessEpisode.PersonnelNumber, tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.FirstDate, tblSicknessEpisode.LastDate, tblSicknessEpisode.SickCategory
FROM tblSicknessEpisode
GROUP BY tblSicknessEpisode.PersonnelNumber, tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.FirstDate, tblSicknessEpisode.LastDate, tblSicknessEpisode.SickCategory
HAVING (((tblSicknessEpisode.SickCategory)="NWR"))
ORDER BY tblSicknessEpisode.FirstDate;