• Replies 1 reply
  • Subscribers 412 subscribers
  • Views 105 views
  • Users 0 members are here
Related

List of Donors who gave more than once last year

Allegra Thompson
$organization

I'd like to send these donors a letter showing their total giving last year. Is there any way in lists criteria to only include constituents who gave more than once in the year?

Thanks!

  • $organization

    I think that this should do it for you if you change XXXX to the Campaign number that you are looking at.  Just create a new list and paste it into show query in the criteria spot 

    If you want to include more than one campaign you can change where campaign_no = XXXX to where campaign_no in (XXX1, XXX2, etc)

    It's for gifts (not pledges and recieved amounts >0 in case of adjustments.

    select distinct customer_no 
    from T_CONTRIBUTION WITH (NOLOCK)
    where campaign_no = XXXX
    and cont_type = 'G'
    and recd_amt > 0
    group by customer_no
    having count(ref_no) > 1
    order by customer_no