3 Replies Latest reply on Feb 24, 2014 1:17 PM by philmodjunk

    Generate Filtered Report From Multiple Related Table



      Generate Filtered Report From Multiple Related Table


           I am currently building a database for a construction company and have run into difficulty trying to figure out how to generate a report that totals specific information from multiple tables. The application I created combines three departments in a construction company into one system. Each department is separate from each other and each department needs to generate a report based on expense totals, labor cost, and invoice job total. I have attached a sample of what I would like the report to look like for reference.

           I have tried using portals on a list format to filter out each expense by department, but I am unable to calculate a grand total on the bottom.

           Field that will determine which department to filter by