Convert #Error to number in report run from blank query

[Guest]

I have a problem and any help would be appreciated.
I have a report built from a query that may or may not return any data. I am
running a total of one of the fields at the footer and this returns #Error
when I open the report.
I would like this to show 0 if there is no information returned by the
query. I have tried the following. Some of the expressions I have tried are
=IIf(Sum([pnum]) Is Null,"0",Sum([pnum]))
=IIf(IsError([pnum])="0","Empty",Sum([pnum]))
=IIf(IsEmpty([pnum])="0","Empty",Sum([pnum]))

All return #Error if the query does not return any data.

Thanks

 

[SusanV]

Look into the Nz function...

 

[Guest]

Try using the IsError function

=IIf(IsError([SumFieldName]),0,[SumFieldName])