Adding Yes/No values in a query

[goaksmith]

I have a query that has 4 yes and no fields. In the query I want to add all the yes values.

ie...

[FieldA]=Yes, [FieldB]=No, [FieldC]=Yes, [FieldD]=Yes, [SumField]=3

I know there has to be an easy way to do this. Any help would be great. Thanks!

 

[KevinM]

Total: ([fielda]+[fieldb]+[fieldc]+[fieldD])/-1

 

[goaksmith]

Thank you so much this worked perfectly. I have been trying to figure out a way to do this for days. At first I tried on the form and this is by far the simplest way. Thank you so much for your help.