can't store correctly a "double" in Access

[caifa]

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 places.

The INSERT statement executes without any error, but when I query the table I see 1.060,00 instead of 10,60!!!

I've tried to set the data type to "Currency" or to set the field size to "Decimal", but neither work...

How can I solve this mistake? Any help would be appreciated!

 

[PHV]

What about this ?
foo = CDec(10.60)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[caifa]

CDec is not available in ASP

 

[PHV]

You may try this:
foo = CCur(10.60)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886