Need a sales receipt (report) from MS Access 2007 with multiple items and multiple payments.
Posted on 2011-05-01
I have a MS Access database in 2007 that controls inventory, clients, and sales. I need to be able to print a sales receipt (report) for a sale that contains multiple items and multiple payments. I have the following tables: Inventory, Clients, Sales, SalesItem, Payments. The sale table contains basic sale information and is linked to both the SalesItem table and Payment table. I have a report based on query, but my problem is that I'm not sure how to get the report to populate correctly for an sale with multiple items and multiple payments. I can get the report to detail the items of a sale and a sum of payments, but I can't get a detail or both.