Problems getting a sum in my query

[JillWelch]

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!

 

[wh00t]

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