So here is the code I am using and calling up the report from a command button for now do not know a better way yet, anyway here goes.

SELECT strain, quantity, location2, userid, date, notes ;
	FROM Veg ;
	ORDER BY strain ASC, date DESC ;
	INTO CURSOR strainreport
SELECT strainreport
REPORT FORM report1cutt.frx  TO PRINTER  PROMPT  PREVIEW
USE   && closes the cursor
SELECT Veg
USE   && closes the table

What happens with this code is the report gets pulled up but it does not sort date descending and if I leave the last 2 lines of code in this snippet I get the error after closing the report preview Alias Veg is not found. It finds Veg in the beginning of the code but not at the end.

Thanks,

Fred W.