>thanks for the help I tried to this syntax
>
>select * ..... into curs mycurs
>select mycurs
>repo form report01.frx prev
>
>it runs but report shows all records not shows where clause eg. where iq<=25
>
As suggested, add the NOFILTER clause to the end of the SELECT statement. The second SELECT is unneeded; you're automatically put in the CWD of the result set.