I'm working on creating a report for our board regarding donations for the end of the fiscal year.

 We have a various funds that donors give to, including our fund to build our new student life centre. I figured out how to query for donors who gave that fund, but I'm wondering if there is a way to query to find which donors gave to ONLY that fund and no other funds? Does anyone know how to do that?

 Thanks for the help!

I use the sub operator in cases like this.   First I query on donors to the fund I want.   Then I query on donors to all of the other funds.   After I create the two queries I sub the query of the donors to the funds that I don't want out of the first query to create a query that includes only donors who gave to the fund I am interested in.   I hope this helps.

Hi,

You might want to use a constituent query with two different summaries, where

Summary1 would include gifts with total amount greater than 0 and fund =’new student life centre’

AND

Summary2 would include gifts with total amount = 0 and fund <> ’new student life centre’

In addition, you might need to consider including specific gift types and/or gift date ranges.

I hope this helps

<> means does not