Recent content by JNLjr

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

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)

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)...