AnsweredAssumed Answered

Summarizing Data based on multiple related tables (relationship filtering)

Question asked by Vinny on Nov 25, 2014
Latest reply on Nov 25, 2014 by philmodjunk

Title

Summarizing Data based on multiple related tables (relationship filtering)

Post

Hello,

I have a simple database structure as follows

Invoice Table:

Invoice_ID

Invoice_Date

InvoiceLine Table:

InvoiceLine_ID

InvoiceLine_Amount

fk_Invoice_ID

fk_InvoiceLine_Type_ID

InvoiceLineType Table:

Type_ID

Type_Name

 

I would like to know how to:

Develop a report or layout that shows:

Type_Name    Sum(InvoiceLine_Amount)

BUT, I want to filter it by a date supplied by the user in the layout.

I can easily show the Sum(InvoiceLine_Amount) totaled by Type_Name; however, getting the date filter involved in this relationship is difficult given the date is in a table related to InvoiceLine.

Can anyone explain how to do this?

Screenshot.png

Outcomes