calculated field showing blank

[ltvrdy]

Hello all -

I'm working with a report that totals the number of times a topic is returned from a query. If a topic is not returned at all, i don't want it to show at all. Currently it is showing a blank field for that topic name and blanks in the count as well. Any ideas? Here's the filter i've put in to pull the right data out of my query:

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

 

[Mihail]

Try DCount function.

 

[ltvrdy]

Thanks for the super fast response... i've tried to use DCount instead of SUM, but in this case that didn't work for me. I recieved the error that my expression contained the incorrect number of arguments. I'm fairly new to Access, is there more to it than just changing the SUM to DCOUNT in my existing expression?