Solved

How to make an alias for zero on a report only

Posted on 2011-02-18
4
257 Views
Last Modified: 2012-05-11
I have a report that displays zero if the value is zero.  OK, but now I need to display the zero as N/A instead of zero.  How do I do this?  One text box I have has this code as the control source.

=IIf([AskPrice]>0,[AskPrice],"")

Thanks

0
Comment
Question by:napsternova
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 250 total points
ID: 34929329
=IIf([MyField]=0,"N/A",[MyField])
OM Gang
0
 

Author Comment

by:napsternova
ID: 34929386
Where would this go exactly?  Is it added to the control source?
0
 
LVL 28

Expert Comment

by:omgang
ID: 34929436
You can add a new, unbound, Textbox control to your report and enter the expression as the ControlSource.
OM Gang
0
 

Author Comment

by:napsternova
ID: 34929465
I think I actually just need to replace the control source that was there.  Thanks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question