And still one MORE way....

Make a single report cursor which has all of the stock numbers, Puritems, etc. Sure it will have repeating fields, but all of your data will be in a single cursor and the report will be easier to design.

HTH
Barbara

>I have two tables that are related by stock number: stockdesc and puritems. The stockdesc table has the stock items described. Puritems includes all of the stock items that are on purchase orders. I have a report that prints out the stockdesc.number, stockdesc.description, stockdesc.onhand, and the puritems.ordered, puritems.delivered. However it only prints out the first purchase order found. I want the report to sum all items that are still on order for that particular stock number and display those numbers on the report.
>
>How do I accomplish this? Thanks in advance.