I need help with the NZ function using a crosstab report

[B555]

Is there a way in a crosstab report to get the Blank (Null) values to be populated with a 0 instead? Here is an example of what I mean.

OArea EAST SE MW WI IL/PL SW
EAST 10 4 3 75 20
SE 18 10 5 MW 4 12 2
WI 4 14 5
IL/PL 44 20 10 25
SW 15 5 15
I have tried the NZ function, and also iff statements.Is there anything else I can try? thanks B555

 

[Crowley16]

nz(fieldname, 0)

--------------------
Procrastinate Now!

 

[B555]

I tried that one already, but it didn't work. I get an Error when I try to run the report. Any other ideas?

 

[gol4]

B555 posted a good solution

What is the error you get

Please post the sql if you would.
I do something like this all the time and don't have any problems.

TRANSFORM nz(Count([direction),0) AS dircount