Originally Posted by
aytee111
Query 1 for donor names: (SELECT DISTINCT Donor FROM TableName)
- now you have all donors
Query 2 for "given" data: select donor and year, Group By donor and take Max for year
- now you have all donors that have given and the last year they gave
Query 3 for information: query 2 and table with data, join using donor and year and bring in the fields that you want
- now you have the information for the last time the donors gave
Query 4, get a full list of donors: query 1 and query 3, left join on donor, bring in name from query 1 and information from query 3