Combining Invoices to Vendor on one Report

[FaxMeBeer]

I am sure that this has been asked, but I cannot come up with the right search terms to find it, I'm sorry.

I have a simple database with two tables (a "vendor" table, and an "invoice" table). Any vendor can have one, or any number of invoices. I want to make a report showing all invoices related to a vendor, rather than a report that has the vendor + one invoice, vendor + second invoice...etc..

I really just want something like a standard statement to be the end result, so that you'd see something like:

-------------------------------------------------------------------------
| Vendor Name |
| Address |
| City, State Zip |
| |
| |
| Invoice # 123456, $1,000.00, Due: 08/31/2020 |
| Invoice # 456123, $1,500.00, Due: 08/25/2020 |
| |
| |
| |
| |
| |
| |
______________________________________________________________________|

All I can manage to produce is a single the an individual page for each invoice, and that isn't what I'm trying for. Thanks for your help!

 

[Toadstool]

Hi FaxMeBeer,

If your Invoices look like this:

Book2
	A	B	C	D
1	Vendor	Invoice	Value	Due Date
2	ACME	123456	$ 1,000.00	31-Aug-20
3	ACME	456123	$ 1,500.00	25-Aug-20
4	Pomer	919191	$ 2,500.00	02-Sep-20
5	ACME	727272	$ 7,500.00	02-Nov-20
6	Pomer	123123	$ 1,230.00	10-Oct-20
Invoices

Then this can produce the Statement for the stated Vendor:

Book2
	A	B	C
1	ACME
2
3
4
5	Invoice	Value	Due Date
6	456123	$ 1,500.00	25-Aug-20
7	919191	$ 2,500.00	02-Sep-20
8	123123	$ 1,230.00	10-Oct-20
9
10
11
Statement

Cell Formulas
Range	Formula
A6:C11	A6	=IF(COUNTIF(Invoices!$A$2:$A$9999,$A$1)<ROWS($A$5:$A5),"",INDEX(Invoices!B$2:B$9999,AGGREGATE(15,6,ROW(Invoices!$A$2:$A$9999)/(Invoices!$A$2:$A$9999=$A$1),ROWS($A$5:$A5))))

 

[Joe4]

Toadstool,
This appears to be an Access question, not an Excel one (posted in the Access Question Forum and mentions databases, tables, and reports).

 

[Joe4]

FaxMeBeer,

Try creating a query between your two tables, put criteria on the vendor field, and use this query as the Record Source for the Report.
If you make it a "Parameter Query", when you go to open the Report, it will prompt you to enter the vendor, and then the Report will just show that vendor.
See here for how to create a Parameter Query: Access 2010: Queries: How to Create a Parameter Query

 

[JonXL]

A feature I've not played with much, but I think you can group the records and set it to start a new page with each group.

Print each group of your Access report on a separate page | TechRepublic

Ensuring that your Access report groups print out on individual pages is just a matter of tweaking your group header property settings. Mary Ann Richardson shows how to do it.

www.techrepublic.com

 

[Joe4]

A feature I've not played with much, but I think you can group the records and set it to start a new page with each group.

Yes, if the goal is to print all of them out (and not just one particular one), that method should work
Basically, you just put the vendor information in the Group Header, the Invoice information in the Detail section, and any Totals you want for the vendor in the Group Footer section.
And you can put the Page Break in the Group Footer section at the bottom.