summing null fields

[colmtourque]

I have looked and looked and do not see an answer?
If I have a report based on a crosstab query that has many null values.
Here is the breakdown
I am trying to do addition adding up several fields but if any one of the fields has a null value it does not return the sum. Is there a workaround for this.

I am just thinking of dropping in and IIF statement into the fields and returning 0 if they are null but I am wondering if there is a better way.
Thanks

 

[pcs]

don't know of any 'work-around'.

Nulls 'propagate'...if any field is a Null the sum will be Null as well.

you would probably find the Nz function easier to use then an IIF.

make sure you use the complete syntax...Nz(Myfield,0) in your query expression.

hth,
al

 

[colmtourque]

nz?
Have never used that before but thanks I will look it up.