Crosstab query results and null vs. zero values

[cmac]

Hello,

I have created a crosstab query for the first time and there are results
that are appearing as null values instead of zero values as they appear in
the data feeding the crosstab query. Is there a way to change these values
to zero as I am having issues creating calculations in a report as a result
of the null values.

Thank you -

 

[tkelley via AccessMonster.com]

Have you tried the nz() function?

nz([YourValueField],0)

http://allenbrowne.com/ser-67.html