I have a Query that is comprised of 4 tables. The 'main' table is 'Estimate table', the second is 'Estimate Items Subform Table', the third is 'Estimate Details Table' and the fourth is 'Change Order Table'.

The 'Estimate Details Table' houses the components that make up the items in the Item subform table. The change order table keeps track of change orders and all of this is linked to the main Estimate Table.

When...

Thanks Neo, I appreciate your patience and guidance. Hard to open the door of learning without the hinge of criticism so no worries there. I have been working on a fix in the mean time and have inched closer. Let me digest your lesson and I will work on breaking down the issue into succinct questions. As a side note I have used a query to calculate the components and then used the total function in the query to get a total. My issue currently...

Thanks Neo...I have seen so many of your responses to other users issues it is a pleasure to actually have you responding to mine. Sorry about the lack of info - wasn't sure where or how to start the convo so I took a stab at it, albeit a rough stab. So, the main form "Estimating Form" has two pages in it "Estimate General Info" and "Estimate details" The General info page control source is an "Estimates only"...

Hello, I have a form that has two subforms - the main form is the estimate form, the first subform is for the items of the estimate the second subform is for the components that make up each item. I have successfully totaled the component subform and calculated the total for each item but I cannon seem to get the items to total for the entire estimate. Here is the equation to total the amount for the Item :
...