>select res
>set order to stuid
>go top
>do while .not. eof()
>ags=tnum/100
>ags2=round(sobt/ags,2)
>repl sperc with ags2
>
>skip
>endd

><<<to things select wrong Database:	MS SQL Server  	Application:Web
> 
>correct is :Database:	vfp	Application:desktop

update Res set SPerc = IIF(tNum = 0, 0, round((Sobt / tNum) * 100,2))