How to show blank if the number field is zero on report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jean (jhsi_at_comcast.net)
Date: 10/22/04 

Date: Thu, 21 Oct 2004 19:18:29 -0700

Hi,

I have a report shows some number fields. But instead of show zeros, how do
I setup an expression on the field to display or be visible only when the
number is <> 0.

Thanks

Jean

Relevant Pages

  • Re: How to show blank if the number field is zero on report
    ... But instead of show zeros, ... > I setup an expression on the field to display or be visible only when the ... Format Property + Number and Currency Datatypes ...
    (microsoft.public.access.gettingstarted)
  • multiple columns error...pls hlp
    ... hi..apperciate any help..thx anywys... ... i need to display the values of a field as columns instead of rows, ... went to "page setup" and set the number of columns to 44. ... you loaded a form or report that has controls or properties that Microsoft ...
    (microsoft.public.access.reports)
  • need a way to display data if checked
    ... I am attempting to do a mail merge within a access report, i have 13 fileds ... I would like to setup the report to display only those ...
    (microsoft.public.access.reports)
  • Report Layout
    ... I have created a report that should display on a legal ... size paper (landscape). ... setup. ...
    (microsoft.public.access.reports)
  • Report Generation
    ... I have a application that allows the user to record staus ... I also have setup a report for the various fields to allow ... displayed on the form, ...
    (microsoft.public.access.reports)