Hello, I am running a query on all donors who have given at least $100 over the past fiscal year. The problem I am having is when I have a donor who has given many times over the past year it lists them each time in the query. I want to have a query with no duplicate donors listed, I want it to list them once for the year with a total they gave for the year.

---

Reply from Richard Rost:

Create an AGGREGATE QUERY. Sum the amount and group by donor.