Zeros in crosstab columns

GraemeG

Registered User.
Local time
Today, 03:27
Joined
Jan 22, 2011
Messages
212
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
 
Last edited:
Try typecasting it with the CCur function;

CCur(Nz([Field], 0))
 
Works a treat!
 

Users who are viewing this thread

Back
Top Bottom