Welcome !

After experiencing a lot of down time, We decided to move this site to CrystalTech.com. CrystalTech.com is powered by only the finest Windows servers providing the best performance, reliability, and value anywhere.

can't store correctly a double in Access

Author	Message

caifa

Total Posts : 3
Scores: 0
Reward points : 0
Joined: 12/3/2009
Status: offline

can't store correctly a double in Access Thursday, December 03, 2009 4:38 AM (permalink)

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

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

caifa Total Posts : 3 Scores: 0 Reward points : 0 Joined: 12/3/2009 Status: offline	Re:can't store correctly a double in Access Thursday, December 10, 2009 9:23 PM (permalink) 0 Anyone could help me on this... Please!
	#2