• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3013
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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