[Margaret Whitaker]

Hi All, I need a memory booster here! The end goal is to have the following two queries:

Query A: A list of donors who have given to the Widgets Fund ONLY and no other Fund
Query B: A list of donors who have given to the Widgets Fund and have given to other Fund(s).

I don't remember how to do this, Thanks!

[Richie P]

IIRC, you'll need two base queries, in order to produce A and B as merged queries.

Query 1: Donors who have given to Widgets Fund
Query 2: Donors who have given to one of (every fund except the Widgets Fund)

then...

Query A = Query 1 SUB Query 2
and
Query B = Query 1 AND Query 2

Am a little rusty right now, so someone may have to come along and correct me, but I think that should work.

[Margaret Whitaker]

Richard, Thank you for the help on this. I will try it and let you know the outcome. Regards, Margaret

[DrewAllen]

Merging queries will work, but I prefer having dynamic queries. You can do a gift summary instead.

Donors with a gift to Widget Fund
and Total Amount of Gifts to funds <> widget fund = 0.

Donors with a gift to Widget Fund
and Total Amount of Gifts to funds <> widget fund is greater than 0.

Drew

[Margaret Whitaker]

Thanks to all of you who took the time to help me out on these queries. I got the results that I was looking for. As always, I'm grateful for these forums.

Regards, Margaret