Using Decimals

A

AHopper

I have been advised to use currency as a field type when using decimals. When
I try to use the data I am getting wrong data.
Example Field "Tolerance" set to currency.
Data Stored "$0.50"
Variable "Dim SinglePackTolerance As Double"
Data picked up as "0.05"

I have tried using "Dim SinglePackTolerance As Currency"
"Dim SinglePackTolerance As Single" "Dim SinglePackTolerance As Integer" all
have given wrong result.

I want to use .50 to multiply another number and .05 is giving me the wrong
answer.

I have other fields in the same table set to currency and the information is
being picked up correctly.
$15.40 picked up as 15.4
$0.74 picke up as 0.74


Should I be using currency for what I am trying to do?

Do I need to format the table field differently?

I thank you in advance for your help.

Allan
 
Top