#Error in report footer

[JP]

I get a #Error value in the report footer when the query recordset is
empty.

The formula is =Sum([amount]).

How can I suppress the error?

 

[Steve Schapel]

JP,

Try it like this:
=IIf(IsNumeric(Sum([amount])),Sum([amount]),0)

 

[Allen Browne]

Try:
=IIf([Report].[HasData], Sum([Amount]), 0)

Explanation in:
Avoid #Error in form/report with no records
at:
http://allenbrowne.com/RecordCountError.html

 

[D.L]

I get a #Error value in the report footer when the query recordset is
empty.

The formula is =Sum([amount]).

How can I suppress the error?