Gianni
asked on
Access query does not show decimal comma
When I query fields in the database with currency information (numeric, 2 decimals), the query results shows all the fileds without decimal commas.
If the query field result, the values in the db like
21671,00 and 23134,18 become 21671 and 2313418
How can I solve the problem of missing decimal information? when the information in the db as decimals value different from 0, this is not shown and 23.134,18 becomes 2.313.418.
Thanks
query-problem.jpg
If the query field result, the values in the db like
21671,00 and 23134,18 become 21671 and 2313418
How can I solve the problem of missing decimal information? when the information in the db as decimals value different from 0, this is not shown and 23.134,18 becomes 2.313.418.
Thanks
query-problem.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the property Formato of Cost_Purchase.
/gustav
/gustav
select "Standard" in the Formato property
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK, how could we know.
/gustav
/gustav
ASKER
I was using Access to connect to an Oracle database using ODBC.
ASKER
Thanks, Gianni
format-property-query.jpg