I have a feeder query, then a pivot query that uses the feeder query, then a Pivot Report that uses the pivot query as its source.
My problem is that when the report displays the data, some of the sums are null values. Therefore, I cannot get calculations done because of the nulls. I have used the IIf(IsNull([fieldname]), 0, [fieldname]) on each of the fields. However, this is apparently only for display purposes or either happens AFTER the calculation field.
I have also tried using a SELECT REPLACE in the feeder query, however, that is all data with no nulls. The nulls happen at the time of the pivotting.
Does anyone have any idea how to get nulls to 0s?
My problem is that when the report displays the data, some of the sums are null values. Therefore, I cannot get calculations done because of the nulls. I have used the IIf(IsNull([fieldname]), 0, [fieldname]) on each of the fields. However, this is apparently only for display purposes or either happens AFTER the calculation field.
I have also tried using a SELECT REPLACE in the feeder query, however, that is all data with no nulls. The nulls happen at the time of the pivotting.
Does anyone have any idea how to get nulls to 0s?
