Iif Counting

[dbasch]

Hello,
I am using a summed Iif statement to count the number of occurences of a specific field value in a report. In this case Yes/No.

I am using the below statements in 2 text boxes to total the Yes and No answers:

=Sum(IIf([Qualified]=No,0,1))

=Sum(IIf([Qualified]=Yes,1,0))

The totals should be:

Yes: 46
No: 6

However, I am getting the same result of 46 from both statements? What am I doing wrong?

Thanks,
Derek

 

[Rich]

Should be =Sum(IIf([Qualified]=No,1,0))

 

[dbasch]

Thanks!