Frequency Query

[Nick Read]

I have a table in Access 2002 for which the last variable
is a rating/score(mark out of ten).

I would like to create a single query that calculates the
frequency of each score (for example it could tell me how
many 1s there were, how many 2s there were, how many 3s
there were etc) and display it in a simple query.

Is this possible and if so how?

 

[Guest]

If the column is called rating and the table tblRating, try

SELECT rating, Count(rating)
FROM tblRating
GROUP BY rating;

Hope This Helps
Gerald Stanley MCSD