June 7, 200718 yr Newbies 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
June 7, 200718 yr Author Newbies 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, 200718 yr by Guest
Create an account or sign in to comment