Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
HT report for One to Many
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement