Rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

Multiply by two, round, and divide by two:

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

John W. Vinson [MVP]
 
Back
Top