Access doesn't see decimal point!

H

Henry

Hello,

I have linked to an Oracle table using Access 2003. The Oracle table
contains a PRICE field which has decimal data such as 15.50. When
querying this data with Access, 1550 is displayed. The decimal point
is missing!
On my other computer which has Access 2002, 15.50 is correctly
displayed.


What could be the issue? Any info would be appreciated.


Thank you,
H
 
H

Henry

I thought of that as well, but the regional settings are the same.
English - Canada

The strange thing is that the data being displayed by the Access query
does have decimal places because when I do a query for (PRICE < 2.00),
I see records such as 172 and 199 which means that Access is treating
those values as 1.72 and 1.99. However, in the query form field, I see
172 and 199! There is no decimal being shown!

This is driving me crazy.... is there anything I am missing?
 
Top