Defining constituents who only gave to one fund or appeal and no others

Lynnette Fisher

Hello -


I am trying to define criteria for a query that would show me constituents who only gave to a certain fund or appeal and nothing else in the past year.  Any help would be greatly appreciated!


Thank you!! 

Lynnette

Alan French

You could probably use the gift summary information for this, at the bottom of the list of query fields.


If you add one summary to include anyone whose total amount of gifts to that fund/appeal during those dates is greater than $0, and then add a second summary to specify that their total amount of gifts to all other funds during that time equals $0, that should hopefully leave you with the group you're after.


Or if you don't want to use the summary information, you could create one constituent query of everyone who gave to that fund and a second query of everyone who gave to something else, and subtract one from the other using merge queries.

Lynnette Fisher

Thank you!