IIF IsError Calculation for report?

[pablavo]

sorry, I really should know this by now.

I want to total the amount on a report with the IIF IsError statement.
I'm just not sure of the syntax,

How would I add it to:
=Sum([Sent]) so that I don't get the error# ?

Thanks

 

[KenHigg]

Maybe:

=Sum(nz([Sent]))

???
ken

 

[pablavo]

Thanks for replying Ken

I was thinking of using Nz but then I wouldn't get anything showing. It would probably be better if I was able to list a "0" to instead of a blank.

Any thoughts on this?

thanks

 

[Rich]

=Sum(Nz(Sent),0))