Access report drops decimal places from field in query
Posted on 2011-02-25
I am creating a query based on data from an Oracle database. The field is defined as number in the database, and I do not have access to change it. The oracle database stores numbers without the decimal places. Value of $23.41 would be 2341. I am calculating the amount by
[field]/100. Works great in the query, but when I put the amount field on a report, it drops the decimal places. If I change the format to currency, it just adds ".00".