• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3125
  • Last Modified:

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
0
Gianni
Asked:
Gianni
  • 3
  • 3
2 Solutions
 
Gustav BrockCIOCommented:
Set the Format property of the field in the query to: 0.00 or 0,00

/gustav
0
 
GianniAuthor Commented:
Where I should set the settings suggested? In which field of the attached image?

Thanks, Gianni
format-property-query.jpg
0
 
Gustav BrockCIOCommented:
In the property Formato of Cost_Purchase.

/gustav
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Rey Obrero (Capricorn1)Commented:
select "Standard" in the Formato property
0
 
GianniAuthor Commented:
The problem was on the settings of the Oracle ODBC Connection string used by MS Access.
The 'NUM' parameter in the ODBC conection string was 'NLS', that I've changet with 'MS'.

After the change on the odbc settings, that you can perform also in the NumericSetting entry of MS registry settings (regedit), I've:
1 rebboted the machine
2 reconnected the database table in the access db

After that, the decimal field was displayed correctly.
You can optimize the format of the field using Set the Format property of the field in the query.


The possible options for the Oracle NUM Connection Parameter field are:
NLS=Use Oracle NLS numeric settings (to determine the decimal and group separator).
MS=Use Microsoft regional settings.
US=Use US settings

The full list of Oracle connection parameter could be found at: https://community.oracle.com/thread/1056197?tstart=0

Gianni
0
 
Gustav BrockCIOCommented:
OK, how could we know.

/gustav
0
 
GianniAuthor Commented:
I was using Access to connect to an Oracle database using ODBC.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now