thank you for reply and code,
it works as value=0.823 ........

but itry at the field as

use newtest
SCAN
ROUND(tper, IIF(tper < .95, 1, 0))
? tper&&no different 
wait
ENDSCAN  

>

>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.........&& percentage result
>>
>>