Query for single-fund givers

Lynne Stern

I'm trying to create a query that will tell me constituents that only give to one Fund. For simplicity, I want to identify those that only give to our Pet Memorial Fund but do not give to any other type of fund, like General Operating, no many how many pet memorials they have given. Is there a way to do this without building out multiple queries? I was able to identify those that have only given 1 gift to the Pet Memorial fund by using the Summary of Gifts, Total Number of gifts less than or equal to 1 AND Fund Description: Pet Memorial. But we have multiple donors that have given multiple gifts to the Pet Fund but nothing else and I don't know how to query for all of them.

Larry Wheeler

You could use your Fund Query and within the Summary of gifts you showed us…

In the main section of your Fund query create a fund description Not One Of the rest of your funds.

Check this carefully as Not One Of is finicky.

Lynne Stern

Thank you! I was so close, wasn't I? Got what I needed!