#Error in calculated field

[Guest]

The following expression is what I am using to add scores from two different
forms. It works if both fields have values in them, but if one field does
not have a vaule it returns #Error. How can I correct this so that it does
not display "#Error" in the field?

=Nz([Eval Grants score]![Text30]+[Eval Tech score]![Text40],0)

TB

 

[Rick B]

=Nz([Eval Grants score]![Text30],0)+Nz([Eval Tech score]![Text40],0)

 

[Guest]

I tried that too and it still returns #Error. Is there anything else I can
do? ;-)

TB

=Nz([Eval Grants score]![Text30],0)+Nz([Eval Tech score]![Text40],0)

--
Rick B

The following expression is what I am using to add scores from two
different
forms. It works if both fields have values in them, but if one field does
not have a vaule it returns #Error. How can I correct this so that it
does
not display "#Error" in the field?

=Nz([Eval Grants score]![Text30]+[Eval Tech score]![Text40],0)

TB

 

[Guest]

I have also tried:

IIf(IsNull([Eval Grants score]![Text30]+[Eval Tech score]![Text40]),0,[Eval
Grants score]![Text30]+[Eval Tech score]![Text40])

This also returns an #Error. Please help.

TB

I tried that too and it still returns #Error. Is there anything else I can
do? ;-)

TB

=Nz([Eval Grants score]![Text30],0)+Nz([Eval Tech score]![Text40],0)

--
Rick B

The following expression is what I am using to add scores from two
different
forms. It works if both fields have values in them, but if one field does
not have a vaule it returns #Error. How can I correct this so that it
does
not display "#Error" in the field?

=Nz([Eval Grants score]![Text30]+[Eval Tech score]![Text40],0)

TB