? Regarding count on control...

[3Mark3]

Hello everyone.
I have a problem I'm Trying to resolve. I have a control in a report called [Completed]. I have, at the bottom of my report footer, a count for that control.

The range of values in this control is either "yes" or "no". I can't seem to count these individually. Can someone help me? Here's how their setup (which isn't working, it's counting everything.).

=Count([completed]=No)
=Count([completed]=Yes)

Am I doing something wrong?

 

[snyperx3]

for no:
=Sum(IIf(Completed=No,1,0))

yes:
=Sum(IIf(Completed=Yes,1,0))

-Pete