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
>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 >>
>>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