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

wasim_sono

Registered User.
Local time
Tomorrow, 01:12
Joined
May 29, 2008
Messages
33
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
Code:
 NZ([SumOfAmount],0)

and
Code:
IIF([SumOfAmount]="",0,[SumOfAmount])

but doesn't work and give space error.

I really grateful for ur replies.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:12
Joined
May 7, 2009
Messages
19,169
on the crosstab query, edit in SQL view:

Transform Sum(Nz(Amount, 0))
 

wasim_sono

Registered User.
Local time
Tomorrow, 01:12
Joined
May 29, 2008
Messages
33
I tried but not working.
 

isladogs

MVP / VIP
Local time
Today, 21:12
Joined
Jan 14, 2017
Messages
18,186
Really? Saying its not working isn't helpful for us to help you.
What exactly happened when you tried arnel's suggestion?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 21:12
Joined
Feb 19, 2013
Messages
16,553
why not use the format property?

0.00;-0.00;0.00;0.00
 

wasim_sono

Registered User.
Local time
Tomorrow, 01:12
Joined
May 29, 2008
Messages
33
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.:)
 

Users who are viewing this thread

Top Bottom