ROUND(value, IIF(value < .95, 1, 0))
>
>i need help to round value as ex.. 0.823 to 0.8 or 68.987 to 69.0 or 56.92 to 57.0
>
>i try round(value,1) it work for 68.987 but for 56.92 round(valuw,0)
>
>i use this code
>
>update newtest set tper=(((ty2010-ty2009)/ty2009)*100/100)*100 where.........
>
>
--sb--