Currency & Null Printing Issue 1

[JNLjr]

I am importing a table from another app into Access97.&nbsp;&nbsp;Using a query I convert a text number to currency (ie. 5 becomes $5.00).&nbsp;&nbsp;The query also converts &quot;NULL&quot; to $0.00. When reporting I would like to only display $.$$ values (ie. $5.00 and NOT display $0.00/ null) in the column.<br>Here is the code from the query bulder:<br>DeckChrg: IIf(IsNull([_10]),0,CCur(([_10])))<br><br>Is there a means to convert Non-Null values only in the query -OR- to display all values except $0.00 in the report????

 

[famousb]

just put a criteria in the currency column of the query that says<br>&gt;0<br>that would only show values of $0.01 or more. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[JNLjr]

The solution you listed will not work because That will eliminate all records that are less than 0 (zero).&nbsp;&nbsp;I want all records to print because of useful info in other fields.&nbsp;&nbsp;I just want this column of the report to be empty on this reord line if the value is less than 0 (zero)

 

[famousb]

ok, in your report itself instead of having DeckChrg visible, have an unbound text box in it's place with a control source of:<br><b><br>=IIf([DeckChrg]&gt;0, [DeckChrg])<br></b><br><br>this will just not show any 0 values, now if you want to be able to show negatives too, then use:<br><b><br>=IIf([DeckChrg]=0,, [DeckChrg])<br></b><br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[JNLjr]

YES!<br>You're solution worked very well.<br>THANK YOU!!!!