Updating totals from one table to another

[michaelb]

Hello All,
People have pledged to give money to an organization. The amount pledged is stored in #TableA, (PledgeAmt) field. TableA also has a (AmountPaidToDate) field. The individual payments on the pledges are in a detail TableB, (PaymentAmt) field. EXAMPLE , One person pledged $1000.00 and made three payments of $100.00 dollars for a total of $300.00 dollars. Another person has pledged $1000.00 and made four payments of $50.00. etc. How do I total the transactions for each person in the detail TableB (PaymentAmt)field and add the total to the (AmountPaidToDate) field of TableA. The solution for this is probably very basic which is where I am right now.


Thanks for your help.

[June7]

Should not do that. Use report to present this data. Aggregate results should not be saved but calculated as needed in reports.

[michaelb]

Thank you June7. That makes good sense.

michaelb