Rounding

[Guest]

Had a look through previous posts but couldnt find any answers for my question:

Im trying to round a number to the nearest 0.5.

eg.
6.7 should be rounded to 6.5
6.8 should be rounded to 7.0

The raw numbers have been used elsewhere in the database for calculations
but need to be rounded for the report.

Thanks in advance

 

[Pieter Wijnen]

see
http://support.microsoft.com/kb/196652

HtH

Pieter

 

[John W. Vinson]

Had a look through previous posts but couldnt find any answers for my question:

Im trying to round a number to the nearest 0.5.

eg.
6.7 should be rounded to 6.5
6.8 should be rounded to 7.0

The raw numbers have been used elsewhere in the database for calculations
but need to be rounded for the report.

Thanks in advance

Multiply by two, round, and divide by two:

Round(2*[number], 0) / 2.

John W. Vinson [MVP]