D
Del
I want to display a number from a table in a report. The number is always
positive and less than 20 and I want an accuracy of one decimal point, e.g.
10.5 but not two decimal points. In the tableI have set the field size to
double with a no formatting, and the decimal places to auto. The number is
fine in the table but it rounds up to the next whole number in the report,
e.g. 10.5 displays as 11. For the text box in the report I have tried
various formats, and auto & 1 in the decimal places setting, all without
success.
What is the fix for this?
positive and less than 20 and I want an accuracy of one decimal point, e.g.
10.5 but not two decimal points. In the tableI have set the field size to
double with a no formatting, and the decimal places to auto. The number is
fine in the table but it rounds up to the next whole number in the report,
e.g. 10.5 displays as 11. For the text box in the report I have tried
various formats, and auto & 1 in the decimal places setting, all without
success.
What is the fix for this?