>>>>Is there a way to send the output of a SUMMARY report created from 4 tables to a new table?
>>>>Thanks
>>>
>>>Raymond, why not just make a SQL to get the summary results you want? (I may be missing something here...)
>>>
>>>Barbara
>>I am already producing a report of all order forms for a month from an SQL of 4 tables. This SQL naturally gives me each order line item. What I am interested in is only the summary of each order for this report and I would like to send the results to a new table.
>>Raymond
>
>Probably you can do an workaround and print the report to an ASCII file, import the file in a table, etc. But this is nasty to be done. Also, everybody expects MS to change the report designer in the future versions of VFP. I don't have more info than you on that, but I prefer to not do workarounds in a VFP part that may be changed seriously.
>
>I believe Barbara is right. Use your cursor/table to extract the data in the way you want using a SELECT-SQL. (Or maybe you can rewrite the SQL you already have.) The result of this SQL will be the table you want. Use the new table/cursor to print the report.
>
>This will be much faster, solid code, almost no risk vs. future changes. Using the Report Designer to build a new table is like using a hammer instead of a screwdriver.
>
>Vlad

OK I need a little help if you can.
From my first query I get a table with the following fields
Order_Number, Order_Date, Company, Order_Line_Item, Cost.

What I get is one record for each ITEM in the order.

What I want to get from this table is a summary for each order, in other words one record for each ORDER
Order_Number, Order_Date, Company, Total_cost_for_this-Order

Can you tell me what to write in an SQL to obtain what I am looking for.

Thanks very much

Raymond