I figured out how to browse the cursor, I switched to some data that had been entered in wrong order on purpose and when I browsed the cursor, the table looking report name it showed me is correct and displays proper.
And when I designed a brand new report with No data whatsoever attached (Thanks Naomi) it still displays from the report not ordering anything But again the cursor is correct.
Any ideas
Oh yeah and is there a statement I could add to the select statement that would only show what strain I want to see aka blueberry, redwood, etc... within the cursor. I tried and strain = blueberry but I think I inserted it at an improper place or my syntax is screwy.
Here is what I am working with now and this cursor works great
SELECT strain, quantity, location2, userid, date, notes ;
FROM cuttings ;
ORDER BY date ASC, strain ASC ;
INTO CURSOR cuttingsreport
SELECT cuttingsreport
REPORT FORM cuttings1.frx TO PRINTER PROMPT PREVIEW
Thanks in advance,
Fred W.