Total of field on continuous forms (2000)

Topic

New Reply

I have a continuous form. In the form footer, I’m trying to get the sum of txtExtended for all records.

How would I manage that? Do I need a query of the underlying table?

Reply | Quote

Replies

=Sum([Quantity]*[Price]) would do the trick. You cannot sum txtExtended itself- you need to sum the formula in the ControlSource of txtExtended.

Reply | Quote

The formula for txtExtended is:
=[txtQuantity]*([txtPrice]-([txtPrice]*[txtDiscount]/100))

When I put a text box in the footer, I made the formula:
=Sum([txtQuantity]*([txtPrice]-([txtPrice]*[txtDiscount]/100)))

Unfortunately, it shows me #Error

Reply | Quote

We’d have to see the database to know what’s wrong.

Reply | Quote

I actually found the problem.

The source for txtExtended should have been:
=[Quantity]*([Price]-([Price]*[Discount]/100))

I needed to reference the fields, not the text box names.

Reply | Quote

Yes, that’s related to SteveH’s advice. You can sum the values of fields and of expressions based on fields, but not the values of controls.

Reply | Quote