AnsweredAssumed Answered

Eliminating multiple gifts for report display

Question asked by MartinLange on Jan 30, 2014
Latest reply on Jan 30, 2014 by philmodjunk


Eliminating multiple gifts for report display


     I have a database where I track donors that need to be thanked. I currently run a script that gives me a list of the donations, donor's name, date given and date last thanked. I thank each donor once a year. When I run the report, I get all of the records for the last 12 months of each donor, except the last 45 days.

     What I would like to show on the report is only one instance of each donor, the most recent donation. What can I do to my script to eliminate all of the extra donations? Here is my script: