Hiding and Showing Zeroes in Reports

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Janet Friesen (anonymous_at_discussions.microsoft.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 13:24:22 -0800

Hello,

I have a report where my calculation isn't working
because one of the fields I'm trying to add sometimes
doesn't have any value in it. How do I show a zero if
there is no number in that field?

Also, how do I show blanks in place of zeroes in a report?

Thanks!
Janet Friesen

Relevant Pages

  • RE: doing calculations using Query Vs Report using Access
    ... I use Expressions in a report to do the calculation, ... Compact and repair your database. ... Make sure all PCs have a copy of the changes. ...
    (microsoft.public.access.reports)
  • RE: doing calculations using Query Vs Report using Access
    ... How about providing some of the "Expressions in a report to do the ... I use Expressions in a report to do the calculation, ... Compact and repair your database. ... Make sure all PCs have a copy of the changes. ...
    (microsoft.public.access.reports)
  • RE: Calculation Using IIf
    ... This is a cumulative report that shows data from ... the percentage is a "rolling" calculation ... "Susan L" wrote: ... I have a crosstab that places the data in rows, and the totals in columns by ...
    (microsoft.public.access.reports)
  • Re: Uncle Als EP testing and EP falsification
    ... > Here is a statement--there are no parameters predicted by calculation ... I'll quote here Uncle Al's entire statement concerning said report ... The other Referee report was four pages long. ... > Here's something to think over--all bulk perfect single crystals have ...
    (sci.physics)
  • Re: String Used in Report Displays as Garbage
    ... Is there anything else in the database that has the name ProductCode? ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)