Adding Null Values

[spow]

I have a subquery that displays a table similar to this:

Query1
--------
[Name,Value1,Value2,Value3]

Some of the Value1, Value2 or Value3's are Null values. How can I add up these values treating the Null values as zero? When I try to add a value to null, it returns null.

Thanks....

 

[JerryDennison]

Use the nz() function:

nz([FieldName],0)