R
rocco
Hello,
I'm developing an application that will stores lots and lots of decimal
numbers.
I'm writing procedure to double check the quality of numbers entered...and I
need to understand one thing...
Despite the regional setting the user can set on his pc, is it true that
Access always use a dots for decimal numbers instead of commas?
Europen countries mostly use commas...so users will easily enter 35,23
instead of 35.23. Now I have checked that the IsNumerc function doesn't give
an error whether you use commas or dots. But if I use SQL to insert data in
the table I get the error: it doesn't like the comma for numbers to be stored
in fields with decimal datatype.
So I'm wondering that in the background, Access will always use dot and no
comma to format properly decimal number.
The workaround will be using the replace function in the SQL statment...but
I just want to be sure this thoughts are right or I'm just having a bad trip.
Thaks,
Rocco
I'm developing an application that will stores lots and lots of decimal
numbers.
I'm writing procedure to double check the quality of numbers entered...and I
need to understand one thing...
Despite the regional setting the user can set on his pc, is it true that
Access always use a dots for decimal numbers instead of commas?
Europen countries mostly use commas...so users will easily enter 35,23
instead of 35.23. Now I have checked that the IsNumerc function doesn't give
an error whether you use commas or dots. But if I use SQL to insert data in
the table I get the error: it doesn't like the comma for numbers to be stored
in fields with decimal datatype.
So I'm wondering that in the background, Access will always use dot and no
comma to format properly decimal number.
The workaround will be using the replace function in the SQL statment...but
I just want to be sure this thoughts are right or I'm just having a bad trip.
Thaks,
Rocco