Having Problems Summing it up

[webjunk]

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.

 

[danvlas]

TotalCurrency= Sum(Cost*Qty)
To sum calculated controls you need to sum the calculation formula...

Good luck,


Daniel Vlas
Systems Consultant
danvlas@yahoo.com