By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,020 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Getting the Sum of a field to populate another field

P: 16
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.
Mar 20 '08 #1
Share this Question
Share on Google+
1 Reply

P: 556
hello there if i'm correct i think you do this
Expand|Select|Wrap|Line Numbers
  1. =forms!yourformnameform2!pledgeamount=forms!yourformnameform1!amountpaid
where it says "yourfornameform1" 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

Mar 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.