Summarizing Data based on multiple related tables (relationship filtering)
I have a simple database structure as follows
I would like to know how to:
Develop a report or layout that shows:
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?