I want to do a simple UNIQUE count of something in a query without it counting repeat values. I have tried changing the options to unique values to no avail. Is there a way to do this (preferably without SQL)?

Here is the Query, I want to count Student ID uniquely-

SELECT Students.[Student ID], Students.First, Students.Last, Avg([Score]/100) AS Expr1, Students.Grade, Students.Site, Count(Results.Score) AS CountOfScore, [Enter Beginning Date] & " - " & [Enter Ending Date or leave blank to see all] AS Expr2, [Assessment Type].[Assessment Type]

FROM ([Assessment Type] INNER JOIN Assessments ON [Assessment Type].ID = Assessments.[Assessment Type]) INNER JOIN (Students INNER JOIN Results ON Students.[Student ID] = Results.[Student ID]) ON Assessments.ID = Results.Assessment

WHERE (((Results.[SES?])=No))

GROUP BY Students.[Student ID], Students.First, Students.Last, Students.Grade, Students.Site, [Enter Beginning Date] & " - " & [Enter Ending Date or leave blank to see all], [Assessment Type].[Assessment Type]

HAVING ((([Assessment Type].[Assessment Type])="Quiz"))

ORDER BY Students.Last;


Thanks!!

"a simple UNIQUE count of something in a query"

Look up DistinctRow in MS Access

thank you for your quick response, unfortunately it still doesn't work for me, I tried "SELECT DISTINCT" and "SELECT DISTINCTROW" and it is still counting duplicate values. Here is the code of a simpler query I set up/

SELECT DISTINCTROW Count(Results.Assessment) AS CountOfAssessment, Results.Site

FROM ([Assessment Type] INNER JOIN Assessments ON [Assessment Type].ID = Assessments.[Assessment Type]) INNER JOIN Results ON Assessments.ID = Results.Assessment

WHERE ((([Assessment Type].[Assessment Type])="Quiz"))

GROUP BY Results.Site;

Thanks again.