6 Replies Latest reply on May 28, 2014 9:22 AM by lelandv

    [Newbie] Charting Q.  Charting quantities of occurences of a specific field in a table

    lelandv

      Title

      [Newbie] Charting Q.  Charting quantities of occurences of a specific field in a table

      Post

           Hi All, 

           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 !

            

           Leland