#Error in subform Tab Control tab footer

[Dwight.Beech]

I have a tab in a subform that I am trying to total some values (rate subtotal, taxes, final total). I have the data setup so the user selects a service type and the number of procedures that will be performed on a valve and it brings the charge rate in and calculates the cost and taxes with a final total on each line item. I have 4 totals in the subform footer that all have the #Error value. I have tried various things summing the field names summing the field formulas to no avail. I read somewhere in previous threads that you can't sum the field name of the text box that holds the value or formula in the subform footer.


Here is an example of the formula in a text box that is in a record in the continuous subform.

=[nbrqty]*[numCost] (name is ExtendedCost)- nbrqty is the number of a procedure to be completed and numCost is the service charge.


Here is the formula in the footer of the subform for this field:
=Sum(Nz([ExtendedCost],0)) - (name is SumExtended) this totals

ExtendedCost.


Any suggestions would be greatly appreciated.

 

[Minty]

Make the extended cost calculation ( and any others) in the forms underlying query.
Then you can sum them in the footer.

Generally this will be quicker, and allows you to easily do what you want.

 

[pbaldy]

I agree with moving the calculation to the query, but if necessary the fix is to sum the calculation:

=Sum([nbrqty]*[numCost])