Can someone point me toward a program or solution that provides the number of queries [combinations] I will need to set up for:

Donors who gave during any of the 3 of the last 5 years (2004 thru 2008).

Thanks.

Dave

dberger@delart.org

If you know SQL you would could write a query in SQL.  There is nothing in the canned package of RE that can do this query for you.

In a pinch for an ad hoc, report you can export all your donors who gave in those years and export the summary total for each year.  You can then write a formula to count if the amount is greater than 0.  Than you can get the number of years a person gave in those 5 years.  Then you can sort by that number and remove anyone whose number is not 3 or more.

Hey Dave - I think I found a solution that will help you out - it's BB150050, and it does involve creating a number of queries to generate this information.

Melissa's right - you can also do this in Crystal.