Hi,
I have some data in a table with gives a value of "Y", "C" or blank for ~20 different columns.
How do i get the query to count how many times "Y" appears in each column separately.
I can get it to do it for one column by adding the field to the query twice and adding a Sum Total with Group By and Criteria set to "Y". If i repeat this for subsequent columns it doesn't do the count independently of the first etc so give the wrong number of "Y" for the rest of the columns.
Thanks,
I have some data in a table with gives a value of "Y", "C" or blank for ~20 different columns.
How do i get the query to count how many times "Y" appears in each column separately.
I can get it to do it for one column by adding the field to the query twice and adding a Sum Total with Group By and Criteria set to "Y". If i repeat this for subsequent columns it doesn't do the count independently of the first etc so give the wrong number of "Y" for the rest of the columns.
Thanks,