Query - counting Yes in Yes/No field

[Carolyn]

This is a novice question I'm sure, but can anyone help?

I'm trying to count the number of 'yes' in a yes/no field.
Am using the 'count' function in query.

many thanks

Carolyn

 

[Allen Browne]

Access stores Yes as -1, and No as 0. You can therefore sum the values to
get the number of yeses.

On a form or report:
=Abs(Sum([MyYesNoField])))

In other contexts:
=DSum("MyYesNoField], "MyTable")

 

[tahir2676]

-----Original Message-----
This is a novice question I'm sure, but can anyone help?

I'm trying to count the number of 'yes' in a yes/no field.
Am using the 'count' function in query.

many thanks

Carolyn
.