Members give more than once but need latest to send letter

[bowlingqt]

I am trying to find the names of people who gave in honor or memory of
someone since 1998. I come up with 1217 but some of these people have given
every year so they appear in the query more than once. I only want to send
them a letter once for the last time they have donated. We code payments as
mem or hon and code their specialty as PAL. Any advice?

Maria

 

[geebee]

hi,

you could use a function... Max() in particular, as in the following example:

SELECT tbl_name.donorID, Max(tbl_name.donation_date) AS last_donation_date
FROM tbl_name
GROUP BY tlbl_name.donorID;

To the preceding, you can add your WHERE clause limiting output records as
desired.

Hope this helps,
geebee