Summing Values from a Subform

[Geodon7]

I have a subform that is linked to the parent form through a field, BillingID. On the subform, there is a field for payment amount. There can be more than one payments made for each BillingID. I need the payment amounts to be summed and display the total amount paid so far for each BillingID. I'm sure this can be done, I jsut don't know how. Any suggestions? If I haven't explained myself well enough, please let me know and I will clarify. Thanks all.

G

 

[Rolliee]

Use DSUM(&quot;fieldname&quot;,&quot;tablename&quot;,&quot;fieldname <> 'something'&quot

rollie@bwsys.net

 

[CosmoKramer]

Add a text box to the form footer of your subform and perform your sum there. On your main form, add a text box and set the field you just added to the subform as its control source.