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.

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

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.

Featured Post

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Introduction
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…

In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…