Problem with > field in report

[jgarnick]

I must be going nuts!&nbsp;&nbsp;I am trying to put an expression on a report that says if an [amt] field &gt; 99.99, place an * on the report, otherwise leave blank.&nbsp;&nbsp;This is my statement&nbsp;&nbsp;Iif([amt]&gt;99.99,&quot;*&quot;,&quot;&quot.&nbsp;&nbsp;It does not work!&nbsp;&nbsp;If I say &lt;99.99, it works!&nbsp;&nbsp;But the values in the [amt] fields are definitely greater than 99.99.&nbsp;&nbsp;I have tried so many variations with formats and values with no luck.&nbsp;&nbsp;I know it is something right in front of me and I'm sure I have done this before, but I can't figure it out! <br><br>HELP!!<br>Thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[jgarnick]

I misspoke with I said the &lt;99.99 works--what I meant was that the expression is evaluating all the amts to be less than 99.99 even if they are not.&nbsp;&nbsp;Go figure.......... <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[RYankowitz]

Just a thought:<br><br>If [amt] is a numeric field, you'll have trouble trying to fill it with a string such as &quot;*&quot; or &quot;&quot;.