What VFP version you're using? The delete syntax should work in VFP8.

>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