Latest donation for each of multiple members

  • Thread starter Thread starter SimonB
  • Start date Start date
S

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?
 
Back
Top