Query on giving in 5 different years, not necessarily consecutive

Options
Maggie meredith
Maggie meredith ✭
Eighth Anniversary First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
Does anyone have ideas of how to set up a query to pull in people who have given in 5 different calendar years?  Doesn't have to be consecutive, just donations in any 5 different years. Th
Tagged:

Comments

  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    Hi Maggie, check these other threads for plenty of ideas on how to do this:

    https://community.blackbaud.com/forums/viewtopic/159/34109?post_id=127228#p127228

    https://community.blackbaud.com/forums/viewtopic/159/13545?post_id=42378#p42378


    And this knowledgebase article:  https://kb.blackbaud.com/articles/Article/41953
  • Christine Cooke 2
    Christine Cooke 2 ✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

    Maggie Meredith:

    Does anyone have ideas of how to set up a query to pull in people who have given in 5 different calendar years?  Doesn't have to be consecutive, just donations in any 5 different years. Th

    If it does not have to be consecutive you use the Summary Fields.  See attached query
  • Alan French
    Alan French ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic

    Christine Cooke:

    If it does not have to be consecutive you use the Summary Fields.  See attached query
    Wouldn't that include someone who, for example, gave 5 gifts in 1996 and hasn't given anything since? They may have 5 different gifts but the query doesn't stipulate that they must've been in different years.

  • Maggie meredith
    Maggie meredith ✭
    Eighth Anniversary First Reply

    Christine Cooke:

     

    Maggie Meredith:

    Does anyone have ideas of how to set up a query to pull in people who have given in 5 different calendar years?  Doesn't have to be consecutive, just donations in any 5 different years. Th

    If it does not have to be consecutive you use the Summary Fields.  See attached query
    Thank you, I will give this a try and see if it's what the requestor had in mind!
  • Maggie meredith
    Maggie meredith ✭
    Eighth Anniversary First Reply

    Alan French:

     

    Christine Cooke:

    If it does not have to be consecutive you use the Summary Fields.  See attached query
    Wouldn't that include someone who, for example, gave 5 gifts in 1996 and hasn't given anything since? They may have 5 different gifts but the query doesn't stipulate that they must've been in different years.

     

    That is something to consider, thanks for mentioning it and I'll check results to see if that is an issue, I appreciate the heads up on this.

  • Christine Cooke 2
    Christine Cooke 2 ✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

    Alan French:

    Christine Cooke:

    If it does not have to be consecutive you use the Summary Fields.  See attached query
    Wouldn't that include someone who, for example, gave 5 gifts in 1996 and hasn't given anything since? They may have 5 different gifts but the query doesn't stipulate that they must've been in different years.

     

    no -- it is looking for number of years given.  I export that info with a summary for each year -- that way you can see by the number of columns populated for they have given 5 or more years.

Categories