We'll first create a Query that isolates the Constituents that gave between specific date ranges using the following steps:

1. Go to Query.
2. Select New Query.
3. Click OK to create a new Constituent Query.
4. Expand Summary Information > Summary For Gift > Total Amount of Gifts.
5. Select greater than or equal to as the Operator. Enter $.01 in the Value field. Click OK.
6. On the Filter tab, add the gift date filters:
(Gift Date between [date range 1]
AND Gift Type equals Cash)
OR (Gift Date between [date range 2]
AND Gift Type equals Cash)
OR (Gift Date between [date range 3]
AND Gift Type equals Cash)
7. Click OK.
8. Expand Constituency and double-click on Constituency Code.
9. Select One of as the Operator and, using the arrows, push the Constituency Codes you would like to include in the results to the right-side field. Click OK.
10. Click Save and close, name the query, save, and close the query.

Then create two Constituent Queries to be merged later. The filters should be as follows respectively:

Constituent Query A: Filter on Gifts > Appeals > Description equals [Appeal A]
Constituent Query B: Filter on Gifts > Appeals > Description equals [All other Appeals] AND Gift Type equals Cash

After creating those queries, create a merge query to isolate those people who only gave to a particular Appeal. This query will be subtracted from our date range query results using the following steps.

1. After saving your queries, select Merge Queries.
2. In the Primary query field, search for Query A.
3. In the Secondary query field, search for Query B.
4. In the Merge operator drop-down, select SUB.
5. Click OK. Click Save and Close. Name, save, and close the query.

Now we can subtract the people who only gave to Appeal A from the query that isolates the constituents of certain Constituency Codes who gave during specified date ranges.

To do so, follow the steps below:

1. Select Merge Queries.
2. In the Primary query field, search for the Query you saved in step 10 above.
3. In the Secondary Query field, search for the Merged Query you saved in step 5 in the latter set of steps above.
4. Select SUB in the Merge Operator drop-down menu.
5. Click OK.