Welcome to Forums Sign in | Join | Help | Forums
in Search


Comparing Donor Giving

Last post 06-17-2008 5:19 PM by Joanie Caselton. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 06-17-2008 10:36 AM

    • Joanie Caselton
    • Top 500 Contributor
    • Posts 36
    • Organization: Lincoln Land Community College Foundation
    • Products:  The Raiser's Edge

    Hmm [^o)] Comparing Donor Giving

    HELP!

    I am trying to run a list of donors who gave between 7/1/97 and 6/30/05 then DID NOT give between 7/1/05 and 6/30/07 but then DID give again between 7/1/07 and 6/30/08.  I can't figure it out.

    I have tried queries, comparative reports, LYBUNT, SYBUNT.  My problem is that I don't know how to build crystal reports.

    Any suggestions?????

    Thank you!!!!!!! 

     

    Filed under:
  • 06-17-2008 1:21 PM In reply to

    Re: Comparing Donor Giving

    This is actually not difficult to do at all and only takes one query using 3 instances of the summary information - total amount field

    Total amount greater than $.01 filtered on gift date between 7/1/97 and 6/30/05
    AND Total amount = 0 filtered on gift date between 7/1/05 and 6/30/07
    AND Total amount greater than $.01 filtered on gift date between 7/1/07 and 6/30/08

    Remember to also use gift type filters in each if you only want cash, etc.

    Melissa S. Graves
    Annual Fund Development Services Manager
    Pathfinder International
  • 06-17-2008 5:19 PM In reply to

    • Joanie Caselton
    • Top 500 Contributor
    • Posts 36
    • Organization: Lincoln Land Community College Foundation
    • Products:  The Raiser's Edge

    Re: Comparing Donor Giving

    THANKS!!!!

     I think this worked.  I was going at it in reverse and it just wasn't working!!!!

Page 1 of 1 (3 items)