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.