AccessKurzo
Dazed and Confused
- Local time
- Today, 01:37
- Joined
- Jan 5, 2001
- Messages
- 55
How would you export Invoice information to Excel with multiple line items and then do a subTotal of Line Items?
I know how to export just the Invoice info or just the line items, but I need something like an access report that contains a subReport - only in Excel
I have 2 queries - one for all Invoice info and another query for the Line Items. I can merger the 2 queries into one, but then I get the invoice info repeated for each line item.
What would be nice is to have the Invoice Info on one line, then have all line items underneath that Line - and continue for all invoices
I know how to export just the Invoice info or just the line items, but I need something like an access report that contains a subReport - only in Excel
I have 2 queries - one for all Invoice info and another query for the Line Items. I can merger the 2 queries into one, but then I get the invoice info repeated for each line item.
What would be nice is to have the Invoice Info on one line, then have all line items underneath that Line - and continue for all invoices
Last edited: