Rounding numbers in reports...

[LewLar]

Hi folks,

I have a report listing a series of decimal numbers...

12.3
9.1
5.7

ect..

I need these to be round to the nearest .5 for the report? How would I go about doing this?

Cheers,

Lewis

 

[Meltdown]

Subtraction Error

Use the Round function:

Round([Name_of_Your_Control])

 

[LewLar]

Use the Round function:

Round([Name_of_Your_Control])

I've tried using;

=Round([turkeyweigth])

but the textbox is just blank when the report is viewed..?

Lewis

 

[KenHigg]

Actually, I think it would be:

Round([Name_of_Your_Field], 1)

???

(Unless you're using '97)

 

[Ukraine82]

Try using the function

Round ( expression, [ decimal_places ] )

hth,
Michael