Hello. I have tables of "Invoices", "Lines" and "Invoice-Line" to create the many to many relationship.
I need to create a report that lists some information about the Line (maybe the name and location) and the dollar amount each month's invoice. How do I do this? Example below. (I am open to other formats as necessary).
Ideally, I would be able to have multiple pieces of information from the Invoice as well, for example the Base Cost and the Total Actuals.