>>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 ;
>         where strain = 'blueberry' ;
>>	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.
>
>

>SELECT strain, quantity, location2, userid, date, notes ;
>	FROM cuttings ;
>         WHERE strain = 'blueberry' ;
>	ORDER BY date ASC, strain ASC ;
>	INTO CURSOR cuttingsreport
>SELECT cuttingsreport
>REPORT FORM cuttings1.frx TO PRINTER  PROMPT  PREVIEW
>CLOSE DATABASES ALL
>

So I inserted this code and now it shows for a split second a report but then closes. I removed close databases all and that had no bearing? only 1 line has been added, is their another statement which should be added or???

Thanks,

Fred W.