wasim_sono
Registered User.
- Local time
- Today, 07:09
- 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
and
but doesn't work and give space error.
I really grateful for ur replies.
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.