Changing null values to zero in Crosstab

[Anthony]

Hi All,

I know this question has been answered before, but I couldn't find the
answer on Google search or searching the boards. I have an Xtab qry and my
val field is spewing out a lot of nulls. I know there is some way to change
these to zero, but Nz doesn't seem to work in Xtab. I used to have a
bookmark for it, but reinstalled OS and now can't find it.

Thanks,
Anthony

 

[Duane Hookom]

You can set your value field to an Expression like
Val(Sum(Nz([YourField],0)))