I have seperate tables for Material Costs, Labor costs, and Commissions. They are all related to the Projects table, so that each project has 3 seperate itemized reports listing all of the Material costs, Labor costs, and commissions. At the bottom of the report it has a TOTAL, adding up each reports items.
I'm wanting to pull these totals to fields in another area of projects. Basically I'm trying to do job costing. So I have fields labeled "Total Commissions", "total Labor costs", and "Total Material Costs". How do I pull the total amounts from each report into the fields I created?