#Error in report calculation where ther is no records

[Alan Forman]

I have totals in a report that work fine if there is a record entered that meets the criteria for the report, but if there is no record, the result of the unbound calculated field on the report is #Error, What do I need please ?

 

[RichO]

You could try using an IIf along with IsNumeric to check the status of the field in question and display a zero or a null if there is no record.

 

[Alan Forman]

Thanks, but I can't seem to get the syntax right, I'm working on it

 

[___]

=IIf(IsNumeric([YourControl]),[YourControl],0)