I have a continous form with the following text boxes:
ID: Automatic ID
Code: Text
Description: Text
Cost: Currency
Qty: Numeric
LineTotal: =Cost*Qty
All except the LineTotal have come from a Table called TAB_Products. On the footer I have 2 other text boxes:
TotalCurrency and TotalProducts which are set to Currency each.
TotalCurrency= Sum(LineTotal)
TotalProducts=Sum(Qty)
The boxes on the footer both give me an #Error. What can be wrong?
Thanks in advanced.
ID: Automatic ID
Code: Text
Description: Text
Cost: Currency
Qty: Numeric
LineTotal: =Cost*Qty
All except the LineTotal have come from a Table called TAB_Products. On the footer I have 2 other text boxes:
TotalCurrency and TotalProducts which are set to Currency each.
TotalCurrency= Sum(LineTotal)
TotalProducts=Sum(Qty)
The boxes on the footer both give me an #Error. What can be wrong?
Thanks in advanced.