Want to creat a summary report in access using to 2 tables?

I have created a database for our Order and Delivery in that i have created to 2 different tables one contains the detail of issued order and other contains the detail of deliveries we receive against each. both table have a common field of PO number. can anyone guide me how to create a report using the 2 tables. what i need is to see how many LPO for a particular Supplier we have issued and against each LPO how many deliveries of each particular items included in that PO we have received and how much is balance.

✅ Answers

? Best Answer

Need more details on the relationships here; we don’t know if 1 purchase order has multiple deliveries, or 1 delivery has multiple purchase orders, or it’s a many-to-many relation… we also don’t know what is an LPO. The question is too vague for an exact answer. However, you need to build a query, and do grouping in order to count.