Display 0 in blank or no data fields (1 Viewer)

[wasim_sono]

I created a report with crosstab query. When I run the report it shows data and some fields which have no data display as blank. I want to replace 0 rather than blank or spaces.

I used

 NZ([SumOfAmount],0)

and

IIF([SumOfAmount]="",0,[SumOfAmount])

but doesn't work and give space error.

I really grateful for ur replies.

 

[arnelgp]

on the crosstab query, edit in SQL view:

Transform Sum(Nz(Amount, 0))

 

[wasim_sono]

I tried but not working.

 

[isladogs]

Really? Saying its not working isn't helpful for us to help you.
What exactly happened when you tried arnel's suggestion?

 

[CJ_London]

why not use the format property?

0.00;-0.00;0.00;0.00

 

[wasim_sono]

Thanks to all who give their precious time. Actually I'm using nz function wrongly. but thanks God as well as all of you that I identify the problem and resolve the matter.