AnsweredAssumed Answered

Eliminating multiple gifts for report display

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

Title

Eliminating multiple gifts for report display

Post

     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:

      

      

overdue10QreportScript.jpg

Outcomes