Hello,
I would like to make invoices using reports. I have four tables- invoices, customers, items and items ordered. I have made a query from these tables that includes the fields name, address, invoice id., good id., description, quantity bought, price etc and also a formula that multiplies the price of a good by the quantity bought. When I make a report from this query I get more than one report for one invoice. For example, if invoice id. 20 has details about a customer who has ordered 3 different items then I will get three reports for each of the three items. What I would like to do is combine all the items bought into one report, and not have a separate report/invoice for each item.
Here is a screenshot to make my problem clearer:
Notice how there is the same invoice id. for each item purchased. I would like all items purchases to be grouped under that same invoice.
Please help.
Thanks in anticipation.
I would like to make invoices using reports. I have four tables- invoices, customers, items and items ordered. I have made a query from these tables that includes the fields name, address, invoice id., good id., description, quantity bought, price etc and also a formula that multiplies the price of a good by the quantity bought. When I make a report from this query I get more than one report for one invoice. For example, if invoice id. 20 has details about a customer who has ordered 3 different items then I will get three reports for each of the three items. What I would like to do is combine all the items bought into one report, and not have a separate report/invoice for each item.
Here is a screenshot to make my problem clearer:
Notice how there is the same invoice id. for each item purchased. I would like all items purchases to be grouped under that same invoice.
Please help.
Thanks in anticipation.
