Return blank if the results is a zero

[FryGirl]

I have a query with the expression

Sum(IIf([CMDB]![RIC]='0004',[CMDB]![QTR2],0))

If the sum happens to be zero, how can I get a blank instead of the zero?

 

[Gary's Student]

How about:

=IF(Sum(IIf([CMDB]![RIC]='0004',[CMDB]![QTR2],0))=0,"",Sum(IIf([CMDB]![RIC]='0004',[CMDB]![QTR2],0)))

 

[FryGirl]

Seems to work just fine, thanks

 

[strive4peace]

actually, instead of "", which IS a value, you can use Null

Excel does not have Null (no value) but Access does ...