report sum question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I'm a newbie at Access and this should be easy - I've read the threads
in reports and in the new section - helped a little but not answered my
question.

I have a report that has donation amounts for individuals - I just want a
grand total at the end. The one I have keeps telling me it's $100 when I know
it's over $10,000 not sure what I am doing wrong.

This is what I have done so far - placed the text box under report footer -
clicked sum and the value in the control source box with runing sum - being
Over All. I'm using Access 2002

thanks for the help
 
Try doing it the old fashioned way, say no to running sum and in your text
box's data source field just put = Sum(Donation)

I'm not remembering why it needs to be this way, but it works and that's
what counts.
 
Back
Top