I'm trying to develop a query that provides a count of the number of records where a certain criteria is true for each field, individually.
I.e.,
How many records where Field 1 = Yes
How many records where Field 2 = Yes
How many records where Field 3 = No etc...
But, I don't want it to be an and or an or statement. I want to know the total number of records for each criteria above. I currently have it set up as the attached screenshot, but that of course results in an and statement.
I.e.,
How many records where Field 1 = Yes
How many records where Field 2 = Yes
How many records where Field 3 = No etc...
But, I don't want it to be an and or an or statement. I want to know the total number of records for each criteria above. I currently have it set up as the attached screenshot, but that of course results in an and statement.