Count Yes/No with Criteria

[Lynn]

I have created a summary query using the Totals button. My Group By field is
Employee ID & my Count field is Attended. Attended is a Yes/No data type.
When I have no criteria in the Yes/No field, it counts the records properly
but when I add No in the Criteria line, the query returns no records.

How can I group by Employee ID & count the number of instances where
Attended = No?

 

[KARL DEWEY]

Use calculated field like this --
Not_Attend: IIF([Attend]=0,1,0)
Then set the Group By to Sum.

 

[Lynn]

Thanks so much Karl! This worked perfectly

Use calculated field like this --
Not_Attend: IIF([Attend]=0,1,0)
Then set the Group By to Sum.
--
KARL DEWEY
Build a little - Test a little

I have created a summary query using the Totals button. My Group By field is
Employee ID & my Count field is Attended. Attended is a Yes/No data type.
When I have no criteria in the Yes/No field, it counts the records properly
but when I add No in the Criteria line, the query returns no records.

How can I group by Employee ID & count the number of instances where
Attended = No?