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