jack nt
01-05-2014, 07:23 PM
when i get the data from access, and put it to excel with code
Cells(RowInput, C_DATA_INPUT) = RS.Fields(StrField)
excel get value different from access (datatype = single)
check in immediate window, the result as follows:
?RS.Fields(StrField)
1.99
?Cells(RowInput, C_DATA_INPUT)
1.99000000953674
? 1.99 = 1.99000000953674
False
?Cells(RowInput, C_DATA_INPUT) = RS.Fields(StrField)
True
who can expain? and how to solve the problem? (excel get exact value is 1.99)
thanks in advance
jack nt
Cells(RowInput, C_DATA_INPUT) = RS.Fields(StrField)
excel get value different from access (datatype = single)
check in immediate window, the result as follows:
?RS.Fields(StrField)
1.99
?Cells(RowInput, C_DATA_INPUT)
1.99000000953674
? 1.99 = 1.99000000953674
False
?Cells(RowInput, C_DATA_INPUT) = RS.Fields(StrField)
True
who can expain? and how to solve the problem? (excel get exact value is 1.99)
thanks in advance
jack nt