Getting the Sum of a field to populate another field

[gedwards]

I'm trying to create a database to keep track of donations. I have 2 tables. One that has all the person information plus the Amt. pledge, Amt. Paid, and Amt. Remaining. The other table had Date and Pledge Amt. Paid.

What I'm trying to do is get the sum from Pledge Amt. Paid in table 2, to populate the Amt. Paid field in table 1.

I've tried using the expresson builder under the Amt. Paid field, I've done =Sum(Table2![Amount Paid]) and that returns an error.

I've also created a query that sums the field for me, but when I try to put the expression into the control source it returns a error for me as well.

I'm just wondering it this is a simple case of me messing up something in the syntax of the expression. Or can this not even be done in Access? My feeling is that its the former.

Any help would be greatly appreciated.

[lee123]

hello there if i'm correct i think you do this

=forms!yourformnameform2!pledgeamount=forms!yourformnameform1!amountpaid

where it says "yourfornamefor m1" enter in your form name there . then in the second part to

i think i had aquestion like this before and they directed me to a page that neopa had written but i ca't seem to find it maybe one of the moderators can help you if this don't work

lee123