Just realised. The select statement SHOULD be accessing ALL the records that your SCAN does. I didn't realise you're selecting from the same table you're scanning. There's no need to do this repeatedly. You WILL only get the same result each time through the loop. In fact, going through the loop is pointless, or counter-productive. All you should need is:

Select * from tax1 where no=m.no and montno between m.nMin and m.nMax ;
into cursor employees
SELECT EMPLOYEES && for the report
report form coptax111 preview

>You're still not selecting the table that is the source for the report
>i.e
>

>m.no=NO
>m.nMin=1
>m.nMax=15
>scan WHILE no=M.NO
>  Select *from tax1 where no=m.no and montno between m.nMin and m.nMax ;
>     into cursor employees
>  SELECT EMPLOYEES                && for the report
>  report form coptax111 preview
>ENDscan
>

>
>NOTE you don't even need:
> Select tax1 &&or select mstr
>because SCAN automatically selects the corect table it scans
>
>
>>hi,
>>ok, i try as under but no skip to another emplyee he get the first employee evry time
>>

>>CLOSE ALL
>>
>>USE MSTR IN 0
>>SELECT MSTR
>>M.DAT=DAT
>>USE tax1 IN 0
>>SELECT tax1
>>
>>m.no=NO
>>m.nMin=1
>>m.nMax=15
>>scan WHILE no=M.NO
>>Select *from tax1 where no=m.no and montno between m.nMin and m.nMax into cursor employees
>>report form coptax111 preview
>>Select tax1 &&or select mstr
>>ENDscan
>>

>>thanks
>>
>>>M