WordTechinc
Programmer
- Sep 4, 2009
- 38
How to compre 2 decimal only?
AmountPD have 2 decimal (ex) 125.54
Discount have 4 decimal (ex) 125.5364
I want to compare AmountPD(125.54) = Discount (125.54).
Here is code;
If .Fields("AmountPD").Value <> .Fields("Discount").Value Then
.Fields("FaceLetter").Value = False
Else
.Fields("FaceLetter").Value = True
End If
AmountPD have 2 decimal (ex) 125.54
Discount have 4 decimal (ex) 125.5364
I want to compare AmountPD(125.54) = Discount (125.54).
Here is code;
If .Fields("AmountPD").Value <> .Fields("Discount").Value Then
.Fields("FaceLetter").Value = False
Else
.Fields("FaceLetter").Value = True
End If