Access doesn't see decimal point!

  • Thread starter Thread starter Henry
  • Start date Start date
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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Pivot table view does not show series data with decimals? 0
Format issue ... 2 decimal places displayed? 19
Trailing Zeroes Stripped from Currency Field in Word Mail Merge from Access 1
Decimal point in bar chart and similar 1
pivot table loosing decimals (vba) 1
Display of numerical value with decimals in a text box 5
ACCESS TO EXCEL 1

Back
Top