AnsweredAssumed Answered

Sub summary report for a set date range

Question asked by NancyatUCM on Feb 26, 2016
Latest reply on Feb 29, 2016 by NancyatUCM

I need to print a report of donors who gave (possibly multiple times) within a specified date range. Here is a screenshot of my sub summary report in layout mode:

Screen Shot 2016-02-26 at 1.34.34 PM.png

 

When I sort by LastName (from Mailing List table), and key and giftdate (from Gifts table), and view in Preview mode I get a nice list of my donors in alpha order with a list of gifts they have each given (dates, amts, and reason) below each donor, a subtotal of what each gave, and a grand total at the end.  My problem is that it shows all of the gifts they have ever given, not just the date range I want.  How could I get the report to show (and total up) only gifts given between 1/13/2015 and 1/13/2016?

 

I'm a pretty basic user, so please answer accordingly - Thanks!

Outcomes