Null to Zero in Crosstab Query

[Alan]

Can anyone explain how to convert Null values to Zero in the Value field in a
Crosstab Query? I know how to use the Nz function but I don't know where to
use it to get it to work!

The Crosstab Query is based on an underlying Select query with aggregate
functions on fields. CountofFieldA is dragged from the Select query into the
design grid of my Crosstab query and I want the Sumof(CountofFieldA) to form
the Value in my Crosstab query and want any Null value for
Sumof(CountofFieldA) to show as zero. The Crosstab query runs perfectly but
frustratingly shows Null as Null.

=Nz([Sumof(CountofFieldA)],0) and =Sumof(Nz([CountofFieldA],0)) don't solve
the problem.

TIA

 

[John Spencer]

Post your query SQL.

Basically, the solution would be something like

TRANSFORM CLng(NZ(Sum(somefieldhere),0))
....