I'm thinking that your report somehow saved Veg table in its DE or is using Veg table instead of a cursor.

Just for test, put alias() at the top of the report (in the Header) and see what will it print.

Also instead of report form just do browse. I believe your select code is correct and the cursor should be created in the right order...

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