Counting multiple Yes/No fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top