>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
SELECT Veg
USE
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 againYou'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.
Randy Bosma
VFP - Because life is too short to code in something else...