Checking if decimal field is > 0

  • Thread starter Thread starter dhstein
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Multiple Decimal Place Formats on Report 6
If then problem 3
Variable Defined as Double is entered in cell with only 2 decimal places 2
Format a Percent 4
Field Size Dilemma 12
Formatting a percent field 1
Format a percent field 1

Back
Top