Query Help

Whitney Shelton

Hey all! I am trying to pull a list based on the following criteria:

I need all donors in our database, excluding those who have only made one tribute gift in their lifetime.

I got the list with all donors who gave one or more gifts, and the tribute equals no, but it is missing people who gave a tribute gift AND other gifts too.

Can anybody help me find the right criteria?

Austen Brown

@Whitney Shelton - I recommend doing this through two queries that you merge together. It sounds like you've got the all donors criteria figured out. Do a separate query that looks for Summary > Summary Gift > Total Number of Gifts = 1; in the associated criteria restrict it to look for a tribute gift.