I can bring in the ingredient weight from the main form and add it to the container weight inside the subreport. But I get a #Name? error when I try to use the calculated cost of raw materials from my main form to add to the container cost within my subreport (which brings in the three or four product specific containers).
I'm hoping someone can see where I'm going wrong!
Main Report Name: rptFinishedProductCostWithContainers
Subreport Name: qryFinishedProductContainers
Main Form Control Source (which successfully calculates and adds ingredient costs): =Sum(([RawMaterialPercent]*[Weight])*([TotalPerUnitCost]))
Subreport Control name: Text 22
Subreport Control Source (this is where I am trying to take the calculated total from the main form and add it to the cost of the container (called TotalUnitCost):
=(Reports!rptFinishedProductCostWithContainers!qryFinishedProductContainers.Report(Sum(([RawMaterialPercent]*[Weight])*([TotalPerUnitCost])))+[TotalUnitCost])
Unfortunately, this results in #Name? error!
Help?!
I'm hoping someone can see where I'm going wrong!
Main Report Name: rptFinishedProductCostWithContainers
Subreport Name: qryFinishedProductContainers
Main Form Control Source (which successfully calculates and adds ingredient costs): =Sum(([RawMaterialPercent]*[Weight])*([TotalPerUnitCost]))
Subreport Control name: Text 22
Subreport Control Source (this is where I am trying to take the calculated total from the main form and add it to the cost of the container (called TotalUnitCost):
=(Reports!rptFinishedProductCostWithContainers!qryFinishedProductContainers.Report(Sum(([RawMaterialPercent]*[Weight])*([TotalPerUnitCost])))+[TotalUnitCost])
Unfortunately, this results in #Name? error!
Help?!