I have a big problem with my Oracle linked tables.
I used a table to check the prices on a retail system.
My Access application let enter new items on the system but the customer ask me if the item is already present on the Retail system and in that case to check if the price is changed.
So to do this I have linked the Oracle tables of the Retail system and with a query I check if the price is different.
I realize that the prices from the linked Oracle table are not showed on the right way.
For example if a price is 119$ it show correct 119 but if the price is 119,90$ it show 1199.
It seems that does not show the decimals separator.
Has anyone already had this problem in the past?
Is there a way to show the linked data in the correct way?
Many thanks