[Newbie] Charting Q. Charting quantities of occurences of a specific field in a table
I apologise in advance for the newbie question. I'm looking for a way of charting the number of occurrences of each of the values in a given field in a table.
In practical terms, I have a table of "people", and in that table there is a field representing the person's "grade" or "level". The value of this can be either undefined or anything from 0 to 10.
I want to create a chart that shows for each unique value in the table for that field, how many rows (people) there are with that value set.
I was looking at potentially doing this with an ExecuteSQL but that only gives me half of the data that I need.
Is there a relatively easy way to do this ?
Thanks in advance !