cName = UPPER(ALLTRIM(thisform.pageframe1.page1.text1.Value)) cNam1 = UPPER(ALLTRIM(thisform.pageframe1.page1.text4.Value)) beg_date = thisform.pageframe1.page1.text3.value end_date = thisform.pageframe1.page1.text5.value SELECT * FROM Mstr; WHERE UPPER(ALLTRIM(Mstr.InName)) == cName AND; UPPER(ALLTRIM(Mstr.Nam1)) == cNam1 AND; BETWEEN(mstr.datein, beg_date, end_date); INTO CURSOR ToReport SELECT ToReport GO TOP SCAN m.a=innoumber ? m.a ,innoumber wait m.b=price m.c=total ENDSCAN GO TOP REPORT FORM mstr22 preview