Counting multiple Yes/No fields

[Guest]

I have a table w/ multiple yes/no fields (i.e. pass roadtest?, pass written
test?). I want to a tally the yes'. How do I do that in a query or report.
Thx, Dj

 

[David F Cox]

-sum([Your_YN])

 

[Guest]

Write an expression that gives 1 for Yes, 0 for no and sums them:

Expr1: IIf([passRoadTest]="Y",1,0) + IIf([passWrittenTest] = "Y",1,0) etc.

 

[Guest]

Sum(Abs([pass roadtest]))