I think you may want to use

for recno() between 1 and 2

and then 3 and 4, etc.

>hi all,
>
>i have at the table 38 records i need to select 2 records evrey time and convert it to excel book
>
>as
>

>select, scan or for  * from mytable first 2records
>copy to book1.sheet1 name is (q1)
>
>next 2 records
>
>copy to book1.sheet2 name is (q2)
>.
>.
>.
>
>end of file
>

>
>thanks