Currency Round UP

[jempie]

Hi there,

I have a field of data that has been created by a query:

6.1
7.6
8.7
9.0
10.2

I want to round up any values with a decimal point between .1 and .4 to .5 and anything between .6 and .9 to the next full number (i.e. 8.1 = 8.5 8.8 = 9.0).

I have searched here and the net and cannot find anything.

Can anyone help?

Thanks.

 

[Mile-O]

http://www.access-programmers.co.uk/forums/showthread.php?t=79158

 

[MarkK]

Function RoundUpHalf(sValue As Single) As Single
   RoundUpHalf = Int(sValue * 2 + 1) / 2
End Function