Histogram Data

[ViaSail]

I have a field that can take text values from a predefined list. I would like to count the number of times that each value of that list is selected in all the records in the database. Basically, it is like getting a histogram of the values in a certain field. Any suggestions will be appreciated.

MD

[Vaughan]

You want a summary report. Read up on the GetSummary() function too.

[ViaSail]

Thanks for your reply. I am familiar with those functions you mention, but not with how to tell them to count the different times a value is selected. In a field, let's say, COLORS, I want to know how many times "white" has been selected, how many times "blue" has been selected, and so on.

Thanks again,

MD

Edited June 7, 2007 by Guest

[mr_vodka]

As Vaughn said, you could use a summary report.

Summary report recent thread