I have a query that lists information for each contributor including the amout they have donated. What I want is a field that will give me a total amount of donations for each person. Right now, I'm getting a list that shows each contributor for each occasion they donated instead of a total.

I get
Jill Welch $20
Jill Welch $10

When I want
Jill Welch $30

I have already tried the sum button which makes "group by" appear in the sort line. But this doesn't work.

Thanks for your help!

click on the group by part, there is a drop down list of all the options available, one of them is Sum