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

 

[Beetle]

Try typecasting it with the CCur function;

CCur(Nz([Field], 0))

 

[GraemeG]

Works a treat!