Blank Fields

[ltvrdy]

I know there are a few threads out there about this, but after reviewing them, i'm not finding the answer. I have a report that is pulling data from a query and on the report, i have a controlled field that is supposed to count only data where a field says "no". Here is the string.

=Sum(IIf([Caller Used Resources]="No",1,0))

when i run the report i get the four results that say no, but i also get a blank field counting the times when this field is blank. If this field is blank, i don't want it to show anything.

Any thoughts?

 

[jdraw]

I suggest you run a separate query to identify what is in those fields. I see nothing wrong with your expression.

You may have N or n etc in those fields.
******---UNTESTED -----********

SELECT
[Caller Used Resources]
,Count(*)
FROM   [COLOR="Purple"][B][I]YourTableNameGoesHere[/I][/B][/COLOR]
Group By [Caller Used Resources];