Numbers Rounding in Report

[skd2726]

I have a report based on a query, the numeric field is formatted as currency with 2 decimal places. When I use this table or query in a report it rounds the numbers in this field. We have changed it to double, single, and long integer but it keeps rounding. How can we get the report to display the correct number?

 

[LittleSmudge]

As well as the data type, accuracy and rounding associated with the field in the table, the control itself has its own set of Formating rules.

You need to check in the design of the report to see if the control has some Format or DecimalPlaces parameter that is upsetting your work.


'ope-that-'elps.

G LS

 

[skd2726]

The control is also set to currency and 2 decimal places and is still rounding - I have set these settings in the table, the query behind the report, and in the report on the control itself and it's still rounding...help