printing zero fields as blanks on a report

[abacuscrp]

I have a report with records that contain several fields. I want to print those with values, but dont want .00 for those that are zero - I want blanks. thanks for all help

 

[famousb]

put this in the formula part of the fields in question in the query controlling the report a formula similar to, then change the controls on the report to reflect the Corrected Field Name<br>
<b><br>
IIf([FieldName]=.00,&quot;&quot<br>
<br>
ie, CorrectedFieldName: IIf([FiledName]=.00,&quot;&quot<br>
</b><br>
this should return the &quot;blank&quot; that you desire. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[JimConrad]

You could also set the FORMAT property...<br><br>The FORMAT property can consist of up to four sections separated by ;<br>PositiveFormat;NegativeFormat;ZeroFormat;NullFormat<br><br>The following format displays positive numbers normally, negative numbers in <font color=red>RED</font>, zero values as the string &quot;Zero&quot; and Null values as the string &quot;Null&quot;<br><br>0.00;0.00[Red];&quot;Zero&quot;;&quot;Null&quot;<br><br> <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>