#Error in calculated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted this question earlier, but still have not found a solution to my
problem. 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],0)+Nz([Eval Tech score]![Text40],0)

TB
 
What's actually in the field: spaces? If so, that might explain why the Nz
function isn't working as it's supposed to.

See whether this works:

=IIf(Len(Trim([Eval Grants score]![Text30] & "")) > 0, [Eval Grants
score]![Text30] ,0)+IIf(Len(Trim([Eval Tech score]![Text40] & ""), [Eval
Tech score]![Text40],0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#Error in calculated field 3
#Error while trying to create DateValue in Access 0
Assigning values to text for calculation 0
Trying to create an audit database inc calculations 4
Division by Zero Error 1
Calculating inventory w/ blank field results 4
Averaging fields, ignoring blanks 3
Yes/No field in Query 1

Back
Top