1 Reply Latest reply on Mar 26, 2014 3:45 AM by erolst

    Subsummary Using Multiple Tables


      I have a database which tracks both rental payments and expenses. There are three tables: tenants, payments, and expenses. I'd like a single report to contain a summary of total annual payments collected by room number, and a summary of expenses by category. I can easily create a report containing total rent payments by tenant, but how can I get both sets of data in one layout, which can also be exported to Excel?


      I have attached a quick draft of the solution.