Insert "0" for Null

[kwooten]

I have a crosstab query that shows some null fields that i would like to say 0.. Is there a formula or setting i can use to do this?



I have:

Div1- Row Heading
Month- Column Heading
Month- Count- Value

Thanks..

[RuralGuy]

Look up the Nz() function.

[kwooten]

Thanks rural.. I thought it was a bit more complicated than it actually was.. If
you look at the Crosstab in the design grid the column being aggregated
had "Count" in the Total Row and the name of the
field being aggregated in the Field row. I changed the Total row to
"Expression" and then change the Field row to Nz(Count(FieldName),0). I got zeros in the output instead of Nulls.

[RuralGuy]

Do you want to go ahead and use the Thread Tools at the top of the thread ansd mark this thread as Solved?

[kwooten]

New problem regarding this... I try to sum by row and it wont let me.. If I have 0, 1, 2, 2, 3 I get 1223 instead of 8... If I take out the NZ function then it wont even count the row, I guess due to the blank field.

[kwooten]

got it...

sum(...)+sum(...)...