#Error

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I am using Access 2003 I have a query where I add three fields together into
a new field in the same query, the problem is if one of the three fields
don't have an amount I get this #Error. Does anyone knows how to deal with
this.
Thank you in advance.
 
Thanks for your help!


Cheers,


PieterLinden via AccessMonster.com said:
CAM said:
Hello,

I am using Access 2003 I have a query where I add three fields together
into
a new field in the same query, the problem is if one of the three fields
don't have an amount I get this #Error. Does anyone knows how to deal
with
this.
Thank you in advance.
Click to expand...

use NZ() to convert the null value to zero, then you can add it.

Total: NZ([Field1],0) + NZ([Field2],0) ...
Click to expand...
 
Back
Top