Changing blank spaces to zero (1 Viewer)

[ALAN]

I use Crosstab query in a report, how to automatically change the blank spaces in the report to zero?

 

[Rich]

Nz([MyField],0)?

 

[ALAN]

I got error message, can u give other suggestions please.

 

[GinaO]

Hi Alan,
did u find the answer to this?
i have the very same problem.
Thanks,
Gina.

 

[Fizzio]

Rich is correct but you need to preceed it with =
ie = Nz([YourField],0)