HI,
I am trying to pull a list of donors who have donated for the past consecutive 5 years. I am having trouble figuring out the best way to pull this list. Any ideas?
Thanks!
Since I don’t know SQL, I do it this way:
· First create SEPARATE lists for each year of giving, i.e. 2009 Donors, 2010 Donors……, 2013
· Next, create a list with each of the above lists as a single line item and using an operator of “HAS”, i.e.
o List has 2009 Donors
o List has 2010 Donors
o List has 2011 Donors
o List has 2012 Donors
o List has 2013 Donors
This list will produce a list of only donors who gave all 5 years.
Barbara Pinney
Tulsa Arts Management Consortium
Thank you!