P
phuser
Main Form contains Unit Information and Totals in text boxes brought down
from the Subform. The subform filters by UnitID and I am trying to calculate
total spent on repairs for this unit, I created a text box on the subform
=Sum([Parts]) and =Sum[(Labor]) and =Sum([Total]) but I still get the #Error
in all 3 columns, some of the invoices (rows) do not contain Labor or Parts
but each row has a total. What else can I try to get the calculations?
from the Subform. The subform filters by UnitID and I am trying to calculate
total spent on repairs for this unit, I created a text box on the subform
=Sum([Parts]) and =Sum[(Labor]) and =Sum([Total]) but I still get the #Error
in all 3 columns, some of the invoices (rows) do not contain Labor or Parts
but each row has a total. What else can I try to get the calculations?