Hi,
I have a frustrating problem concerning the comparison of numeric values.
I have two values held in:
Dim Val1 As Double
Dim Val2 As Double
On the debugger the values are both the same but when I action the code:-
If Val1 <> Val2 Then
MsgBox ("Error"
End If
display "Error"
The difference is 7.27595761418343E-12
The values have been derived from an Access database.
Has anybody got any ideas as to where I should start looking in order to resolve this?
I have a frustrating problem concerning the comparison of numeric values.
I have two values held in:
Dim Val1 As Double
Dim Val2 As Double
On the debugger the values are both the same but when I action the code:-
If Val1 <> Val2 Then
MsgBox ("Error"
End If
display "Error"
The difference is 7.27595761418343E-12
The values have been derived from an Access database.
Has anybody got any ideas as to where I should start looking in order to resolve this?