Using HAVING COUNT SQL to return specific results

[benny1983]

I have an audit report that opens based on a query of reviews for a certain quarter that have not been sent.

The issue I am having is that I only want the clients name to come up on my report once the unsent audit count reaches 10 or more.

Here is my SQL so far which works fine - I just need some guidance on only returning the result when the count of audits reaches 10+.

I read about HAVING COUNT however cannot get that to function correctly. Any help is much appreciated.

SELECT DISTINCT tblQAAuditRecords20141.Provider
FROM tblQAAuditRecords20141
WHERE ((([tblQAAuditRecords20141].[QAQuarter])=[Enter QA Quarter]) And (([tblQAAuditRecords20141].[QAReportSent])=False))

[benny1983]

A bit of further research and came up with the following which works perfectly!

SELECT DISTINCT tblQAAuditRecords20141.Assessor, COUNT(Provider)
FROM tblQAAuditRecords20141
WHERE ((([tblQAAuditRecords20141].[QAQuarter])=[Enter QA Quarter]) And (([tblQAAuditRecords20141].[QAReportSent])=False))
GROUP BY Provider
HAVING COUNT(Provider) >9;