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?
 
Choose a totals query and Group by the member and Max on the donation date.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Donations - Mail Merge 11
Counting multiple memberships 1
Query of donors by number of donations made 5
Append Query Major Complication 11
Show last donation by each Company 4
Achieving a grand total of five or more fields for a period of tim 1
No results when adding 2nd table to query 1
Help Totaling More Than One Entry 2

Back
Top