How do I calculate a distribution

[Donald Dudar]

I have a query that shows the responses from participants
in a survey. I now want to create a table, and then a
graph, that shows the frequency of each response, that is,
how many people reported value "1", how many value "2" and
so on.

Is there an easy way to do this?

Thanks

Don

 

[JohnFol]

Yes, use a group by query where you group on the answer, and also have a
Count(answer)