Zeros in crosstab columns

[GraemeG]

Hello.

I have a crosstab query which produces figures depending on the table.
However some of the cells in the columns are blank when zero. Is there a way to show the zeros?


However I know I can use Nz([field],0) to get the zeros. But this then will not let me make the fields Currency which is what I need. any ideas?

Thanks

[Rhino373]

Does Ccur(NZ([Field],0)) work?

[GraemeG]

Yeah thanks!