Hi, I am trying to create a query where it will count the occurance of distinct elements in a column. Example: Column name is Question1, and its values can be any of the following: ‘Excellent’, ‘Good’, ‘Fair’, ‘Poor’. I would like to run a query to see how many ‘Exellent’ has been entered, how many ‘Good’ has been entered and so forth. Only thing I could do is to write a single query for each element, which will be crazy because I have 35 of such question columns. Can someone please help me?????