>>Alright I got the cuttingscursor.prg working just fine it displays in the correct order on the report as far as date, the last thing I am trying to do is be able to have the cursor only display strain=blueberry, redwood, etc...... I have tried inserting it and I guess in the wrong place.
>>
>>Any ideas
>>
>>Fred W.
>
>Hi Fred,
>
>Remember we talked yesterday about custom form for selections?
>
>Anyway, show your select statement again and just add WHERE Strain = 'blueberry' in the WHERE clause.
>
>Also before replying go to the top right corner on the message. It should show you the context menu. Select the last item in there called Enable AutoQuote.
>
>This way the original message would be included into the reply and we would be able to answer you more easily.
So from MS example in the help file it looks like I am supposed to insert the line where strain=blueberry or ??? is after the from line but when I insert this line I get the error SQL column blueberry is not found. below is the working code I have so far
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
CLOSE DATABASES ALL
As usual confused over something probably very simple I am sure.
Any ideas.
Thanks,
Fred W.