>>>>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.
>
>It means that the strain name is something different. Insert the actual name, say, 'Blueberry' or change the condition to upper(strain) = 'BLUEBERRY'
>
>Also you may try right after select statement
>

>if _tally = 0
>  =messagebox('Sorry, no records match your criteria...',0,'No Records')
>else
>  report form ...
>endif
>