Latest donation for each of multiple members

[SimonB]

I have a query that selects all donations from all
members in a charitable organization, linking the Members
table and the Donations table. I need to select from
that only the latest donation from each member so I can
see when it was, and send him a renewal letter if it was
longer ago than 12 months. How can I do that. The MAX
and DMAX functions applied to the contribution date only
give me the single record with the latest date, not one
for each member. Can anyone help me with this?

 

[Joan Wild]

Choose a totals query and Group by the member and Max on the donation date.