Access

[John]

I have down loaded from Microsoft a free program for
Access. It is called MAIN SWITCHBOARD. It is for non
profit groups that take donations from people. My
question is this. There is a field called amount pledged.
I would like to have a field called TOTAL AMOUNT PLEDGED
for that one person, so I can see how much that
particular person has given. Can some one tell me how to
do that?

 

[John Vinson]

I have down loaded from Microsoft a free program for
Access. It is called MAIN SWITCHBOARD. It is for non
profit groups that take donations from people. My
question is this. There is a field called amount pledged.
I would like to have a field called TOTAL AMOUNT PLEDGED
for that one person, so I can see how much that
particular person has given. Can some one tell me how to
do that?

I don't have that particular app, but any time you want a total it
should be calculated on the fly, not in a Table. I would suggest
putting a Textbox in the footer of a Report with a Control Source of

=Sum([amount pledged])

or whatever the actual name of the field is.