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
>SELECT Veg
>USE
>
>
>
>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.
If it's not broken, fix it until it is.
My Blog