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

wasim_sono

Registered User.
Local time
Today, 18:49
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

error reading drive A:
Local time
Today, 22:49
Joined
May 7, 2009
Messages
9,279
on the crosstab query, edit in SQL view:

Transform Sum(Nz(Amount, 0))
 

wasim_sono

Registered User.
Local time
Today, 18:49
Joined
May 29, 2008
Messages
33
I tried but not working.
 

isladogs

CID Moderator
Staff member
Local time
Today, 15:49
Joined
Jan 14, 2017
Messages
13,132
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, 15:49
Joined
Feb 19, 2013
Messages
12,091
why not use the format property?

0.00;-0.00;0.00;0.00
 

wasim_sono

Registered User.
Local time
Today, 18:49
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 (Users: 0, Guests: 1)

Top Bottom