Summing payments

[Guest]

I have a form with a subform.

The subform has a list of payments.

I would like to have a field on the form with a total of the payments listed
in the subform.

I have tried to use =Sum(subform.subform payment field)

I just get an error message.

I have also notice there is no options similar to a report to keep a running
sum on the payment field.


Any Ideas?

 

[Al Camp]

Stefan,
Try placing an unbound text control in the Footer of your subform with a Control Source
of...
= Sum(YourPaymentFieldName)
Name that field something like SumOfPayments

On the Main form place an unbound text control with a Control Source of...
= SubformName.Form!SumOfPayments
will display the value from the sub total.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.