Rounded numbers in Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Del - 30 Apr 2008 21:43 GMT

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?

Signature

Thank you,
Del

Reply to this Message

Marshall Barton - 30 Apr 2008 23:31 GMT

>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.
[quoted text clipped - 4 lines]
>various formats, and auto & 1 in the decimal places setting, all without
>success.

The Format 0.0 should do that. If it doesn't, then it
implies that the report's record source query or the text
box expression is somehow converting the number to an
integer/long size.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Del - 01 May 2008 17:43 GMT

Thanx. That was an easy fix

Signature

Thank you,
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.
[quoted text clipped - 9 lines]
> box expression is somehow converting the number to an
> integer/long size.

Reply to this Message