report sum question

K

Kelly

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
 
D

DevalilaJohn

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