Khubaib,
Why you sorry?
I am still using VFP DB engine :-)

About your qustion:

SELECT lcode,;
       sec,;
       descr,;
       examcode,;
       sum(tobt) as tobtt,;
       SUM(tmax) as tmaxt;
FROM Examtran;
WHERE examcode=thisform.code.value .and.;
      scode>=thisform.shiftfm.value .and. scode<=thisform.shiftto.value;
GROUP BY lcode,sec;
INTO CURSOR tyu

SELECT lcode,;
       sec,;
       descr,;
       examcode,;
       tobtt,;
       tmaxt,;
       TRANSFORM((tobtt/tmaxt)*100,"##.##") AS PERCENTAGE;
FROM tyu;
WHERE examcode=thisform.code.value .and. scode>=thisform.shiftfm.value .and. scode<=thisform.shiftto.value;
GROUP BY lcode,sec;
INTO CURSOR ppp
SELECT ppp
brows

What exactly is the error?
BTW the WHERE clasue in second select is useless, becaouse you already get the filtered recordset in first one.