counting the YES responses

[eramirez]

Hi

I have a field called TYPE and a series of check boxes for reasons a person picked that type. I want to add up all the checked responses (YES) and group by TYPE. When I setup my query and add TYPE and for total I chose Group By, then I add in each of the checked (yes/no) fields and for total I chose Count, in the criteria I type in Yes because I only want to count yes responses. when I run the query, it groups it fine, but the counts are wrong and they are the same for each row of TYPE. For example, TYPE A, all the counts are 50, TYPE B all the counts are 7. What am I doing wrong?

Thanks for any help you can provide!
Enrique

 

[georgedwilkinson]

Can we see the SQL of your query, please?

 

[FoFa]

I think (think being the key word) you are expecting the YES criteria to apply to a column, but it does not work that way, it applies to a row. So if you have C1's criteria set to YES and C2's criteria set to YES, and in row 1 C1 = yes, and in row 2 C2's value = YES, and you have the criteria in the OR (one line down form each other in criteria) than it would always return 2. If the YES was all on the same criteria row, it would only return those rows where ALL yesses were met, in this example above, none.