Thanks for your help!


Cheers,


"PieterLinden via AccessMonster.com" u49887@uwe wrote in message
news:a8503402827a2@uwe...
CAM wrote:
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.

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

Total: NZ([Field1],0) + NZ([Field2],0) ...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1