#Error

[Guest]

Hi thanks in advance.

I am bringing a Total from a sub form to a main form. If no records in sub
form get #Error. I need to have 0(Zero) not Error.

Can't stop it. I have tried nz, is null and iif


Thanks


Trev

 

[Guest]

Try this in the field in the main form

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