hi,
ok,it works,but i need to get m.dat at my report,m.dat=dat this field at mstr table he get the same m.dat for all emplyee.

CLOSE ALL
USE MSTR IN 0
SELECT MSTR
M.DAT=DAT
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 tax1
  report form coptax111 preview

ENDscan

>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