MS Access Functions with Null Values

[Pettor]

Hi All and Happy New Year,

I have the below function in an MS Access query where I want to add two Expresions from this query. Unfortunately when one of the values is null, the outcome is again a null value.
Can someone help me on how to substitute the null value with zero so as to get the correct outcome?

(AV_FT_GL_H_HM+AV_FT_GC_A_AW)/2 AS EST_GL_H_HM,
(AV_FT_GL_A_AW+AV_FT_GC_H_HM)/2 AS EST_GL_A_AW

Thanks

 

[Pettor]

Basically, what I am trying to do is to substitute a null value with 0 when the sum of a function (i.e. Sum(Table.Value) is Null.
Is it possible?

 

[Pettor]

Hi All,

I think problem is solved by using the NZ function, replacing Null with Zero.