>>>>

>>>>I have two tables: 
>>>>exam has fields : code,obt01.
>>>>hwsv has fields:code, perc
>>>>e.g
>>>>
>>>>code         perc
>>>>1              100
>>>>2              89
>>>>3             70
>>>>.....
>>>>i want to update exam field  obt01 with  hwsv filed is perc.
>>>>
>>>>like this.
>>>>
>>>>if  perc is 100  replace exam field with 10
>>>>
>>>>
>>>>if  perc is 80  to 99  replace exam field with 9
>>>>if  perc is 70 to 89  replace exam field with 8
>>>>............
>>>>

>>>
>>>Something like
>>>

>>>update Exam ;
>>>set Obt01 = ceiling((Perc+0.9)/10) from Exam inner join Hwsv Hv ;
>>>on Exam.Code = Hv.Code

>>replaced all records with 1
>>need more help
>
>Start with the select first - verify that select produces right data. Then turn SELECT into update.
sorry Noomi: i can not under stand