>That worked great! One last thing their is a date field in the report is there a way to get the report to show the oldest records first (by date entered).

Based on your earlier message (at 21:38 last night):

SELECT strain, quantity, location2, userid, date, notes ;
	FROM Veg ;
	ORDER BY strain ASC, date DESC ;
	INTO CURSOR strainsales
SELECT strainsales
REPORT FORM sales_by_strain  TO PRINTER  PROMPT  PREVIEW
USE   && closes the cursor
SELECT Veg
USE   && closes the table

In your report you total (SUM) the quantity field in the group footer as Rich explained so well.

Sooner or later you'll probably want a WHERE clause to restrict the data to the last month or last quarter or the current year, whatever the client needs.

>I am still going to have to design individual reports a bunch!!

Only one report would be required for any or all strains. You're not thinking that you need a BlueberryStrain.frx and a RedwoodStrain.frx and a ........,? Just use the 'strain' field in one of the headers.

Thanks again

You're welcome again. :-)

P.S. Using 'date' as a field name is not advisable, as it is also a keyword in the language and may cause problems that are very challenging to debug.