Zeros to replace nulls in Crosstab

  • Thread starter Thread starter Paul Ilacqua
  • Start date Start date
P

Paul Ilacqua

Is it possible to replace nulls with zero's in a crosstab's value field
IIF(IsNull(XXX),0,XXX) does not seem to work. Please help if possible.
Thanks in advance.

Paul
 
I can't get NZ or the old fashion way to work in a crosstab value field. Has
anyone else?

Paul



Rick B said:
The Nz function erplaces nulls...


Nz([SomeFieldName],0)



Paul Ilacqua said:
Is it possible to replace nulls with zero's in a crosstab's value field
IIF(IsNull(XXX),0,XXX) does not seem to work. Please help if possible.
Thanks in advance.

Paul
Click to expand...
Click to expand...
 
Yes, I have. Can you post your SQL statement? and identify which field you
want to show as zero? The SQL should start with something that looks like the following.

TRANSFORM CDbl(NZ(Sum(FAQ.fID))) AS [The Value]
....

Paul said:
I can't get NZ or the old fashion way to work in a crosstab value field. Has
anyone else?

Paul

Rick B said:
The Nz function erplaces nulls...


Nz([SomeFieldName],0)



Paul Ilacqua said:
Is it possible to replace nulls with zero's in a crosstab's value field
IIF(IsNull(XXX),0,XXX) does not seem to work. Please help if possible.
Thanks in advance.

Paul
Click to expand...
Click to expand...
Click to expand...
 
Back
Top