fsupport1600
MIS
Version: Access 2007
I have a text box (txtTotalCost) with the following control source: =([SumOfQuantity]*[ProductPrice]) on a report
However, I want to calculate the total sum for all these text box values but I get the #Error.
I created a new text box (txtSumTotalCost) and entered the following for the control source:
=Sum([SumOfQuantity]*[ProductPrice])
Also tried the following with the same results.
=Sum([txtTotalCost])
Is it true that access can not calulate a based on text box name when that text box already has an expression?
I have a text box (txtTotalCost) with the following control source: =([SumOfQuantity]*[ProductPrice]) on a report
However, I want to calculate the total sum for all these text box values but I get the #Error.
I created a new text box (txtSumTotalCost) and entered the following for the control source:
=Sum([SumOfQuantity]*[ProductPrice])
Also tried the following with the same results.
=Sum([txtTotalCost])
Is it true that access can not calulate a based on text box name when that text box already has an expression?