Access

  • Thread starter Thread starter John
  • Start date Start date
J

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?
 
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?
Click to expand...

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.
 
Back
Top