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