Zeros to replace nulls in Crosstab

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
 
P

Paul Ilacqua

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...
 
J

John Spencer (MVP)

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Null to Zero in a crosstab 1
Crosstab queries, <> and null values 3
Crosstab Query show null values 3
Replacing Nulls with zeros 10
Fill Blanks with Zero on CrossTab 4
handle Null 6
Crosstab with multiple fields 2
sorting columns in crosstab query (xxx@0, xxx@1, xxx@2, ... , xxx@N) 3

Top