Thanks Randy. I placed the code after the IF Block, but noticed that the table "revisedapps" did not show up in the datasession window.

I even tried placed the code right after completing the select statement which is as follows:

select * from changedappointments into cursor changedappsinfo nofilter;
	where changedappointments.datechange >= mrepbegindate .AND. ;
	changedappointments.datechange <= mrependdate  ;
	group by changedappointments.localdoc,changedappointments.pat_name ;
	order by changedappointments.localdoc, changedappointments.pat_name
        COPY TO revisedapps TYPE FOX2X

The above code is just one part of the if/else condition. Am I doing this right? Thanks for your help.

- Ravi