Iif Counting

dbasch

Registered User.
Local time
Today, 18:23
Joined
Jan 27, 2003
Messages
13
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
 
Thanks!
 

Users who are viewing this thread

Back
Top Bottom