Hi folks!
I can't store correctly a "double" into an Access database (I'm using ASP/Vbscript).
Specifically I have a variable, with 2 decimal places:
foo = FormatNumber(CDbl(10,60),2)
I want to insert this variable in Access in a field with type Number, Field Size Double and 2 decimal...
I have a field, let's call it Field D, that is the result of a calculation.
field D = field A + Field B - Field C
sometimes the calculation works, but in some cases it returns incomprehensible values, i.e. -8,8817842E-16 (whereas I expected to find 0)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.