Checking if decimal field is > 0

D

dhstein

If I have a field defined as Decimal, I'm using variables Dimensioned as
"Double" for that data. If I want to compare if greater than 0 is the code
below correct ?

Dim MyDecimalValue As Double


MyDecimalValue = rsSomeRecordSet!SomeDecimalField

If MyDecimalValue > 0 Then

........ some code here

End If


' ************
' Or Maybe I need :

If MyDecimalValue > 0.0 Then

........ some code here

End If

Thanks for any help
 
D

Douglas J. Steele

If MyDecimalValue > 0 Then

should be fine. What happened when you tried?
 
Top