Members give more than once but need latest to send letter

B

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
 
G

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
 

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

Top