G
Guest
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
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