Rounding Number to nearest half 2

[TimTDP]

In access 2000 I need to round numbers to the nearest half
ie.
10.30 becomes 10.50
10.20 becomes 10.00
10.65 becomes 10.50
10.85 becomes 11.00

how can I do this?

 

[Remou]

How about:

[tt]Y = IIf(X - Int(X) < 0.26, Int(X), IIf(X - Int(X) < 0.76, Int(X) + 0.5, Int(X) + 1))[/tt]

 

[TimTDP]

Thanks
I was hoping for an inbuilt function!

 

[CaptainD]

How about

Select Round(Num * 2, 0) / 2

Note: GMastros gave me this for SQL server, not sure if it works with Access.

 

[Remou]

Thanks for that, CaptainD, it works for me.