General discussion
October 11, 2005 at 07:45 PM
kosheno

I need a ‘countif’ equivalance in Access

by kosheno . Updated 20 years, 11 months ago

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?????

This discussion is locked

All Comments