>>>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