I am trying to filter the records, like this.

SELECT Examtran.*;
 FROM examtran;
where code>=thisform.codefm.value .and. code<=thisform.codeto.value ;
			  .and. sec>=thisform.secfm.value .and. sec<=thisform.secto.value ;
			  .and. scode>=thisform.shiftfm.value .and. scode<=thisform.shiftto.value ;
			  .and. lcode>=thisform.levelfm.value .and. lcode<=thisform.levelto.value ;
			  .and. year>=thisform.yearfm.value .and. year<=thisform.yearto.value;  
              .and. nmonth>=thisform.nmonthfm.value .and. nmonth<=thisform.nmonthto.value;
              ORDER BY result;
               INTO CURSOR bbb 




SELECT bbb.*;
 FROM bbb;
where code>=thisform.codefm.value .and. code<=thisform.codeto.value ;
			    AND change1=1 AND bex=2;
              ORDER BY descr;
               INTO CURSOR bbbc 


	REPORT FORM ALLTRIM(thisform.file.Value)preview
	

But in report i am not getting required result.should i changes some in report