hi,
i get error message 'sql:Queries of this type are not supported '
at this statment under..

 delete from table1 where recno() in (select RecNum from crsRand)

for report
i put the report form rpt1 preview as

    endscan
REPORT FORM rpt1 preview
use in curPercentage 

and i compute the number of record before mutiply in side myreport
it works.
thanks