Query Help

Whitney Shelton
Whitney Shelton
Kudos 3 Third Anniversary Name Dropper Participant
in Blackbaud Raiser's Edge NXT®: General Discussions

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?

Comments

  • Austen Brown
    Austen Brown Community All-Star
    Tenth Anniversary Kudos 5 PowerUp Challenge: Product Update Briefing Feedback Task 3 bbcon 2025 Attendee Badge

    @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.

Categories