Substitute null value with "0"

[Roach]

Hello all,

My problem is this....I have 2 fields, "Yes" and "No". Some of these fields are null and others are populated. I'm trying to build a relatively simple query which adds yes' and no's.

The problem is that IF I have 3 yes' and null (zero) no's the addition expression gives me a null field.

Is there an expression that will throw a "0" in the null fields so the addition expression can actually add 3 plus "0"?

Any help is greatly appreciated. Thank you very much.

Peace,
Roach

 

[pdx_man]

Check out the nz() function

 

[Dave Eyley]

Or the IIf() function.

Dave E