iif stmt and rounding

[was1]

I created an iif stmt : iif([GrossAmt]=[NoteAmt]"Match","Research")

My problem is that there is some rounding going on that creates a "Research". What can I do to eliminate the rounding? The variance is so small that I want it to show a "Match".

Example:
Gross Amt: $100.00
Note Amt: $100.00
Var: -4.54747350886464E-13

 

[PHV]

Perhaps something like this ?
IIf(Abs([GrossAmt]-[NoteAmt])<0.01, "Match", "Research")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[was1]

Thank you! Thank you! Thank you! works perfect!!