Hi,
I have table with 2 fields
f1 char(20)
f2 number(5,2)

The f2 column values are:
4.10
5.23
7.32

I need to round the decimal part like this; if the decimal part is in range:
1-15 => 15
16-30 => 30
31-45 => 45
45-59 => decimal part should be 0 and 1 should be added into integer
column.

Example:
1.09 => 1.15
1.23 => 1.30
1.36 => 1.45
1.48 => 2.00

Can anyone help me out, how can this be done in MS Access.
Thanks
Zafar