Turning off "null propagation" when adding fields

[rdra90]

I'm trying to add three numeric fields together in a query. Some of the
fields will have null values (in this context, the same a zero) from time to
time. Because of "null propagation," I get a null sum if any one of the
three fields is null. I want the sum of the available field values even if
one or more is blank. How do I do this?

 

[fredg]

I'm trying to add three numeric fields together in a query. Some of the
fields will have null values (in this context, the same a zero) from time to
time. Because of "null propagation," I get a null sum if any one of the
three fields is null. I want the sum of the available field values even if
one or more is blank. How do I do this?

Look up the Nz function in VBA help.

TotalOfFields:Nz([FieldA],0) + Nz([FieldB],0) + etc....