1. Create a constituent query.
  2. On the Criteria tab, select Gift, Gift Appeal Description one of [the two appeals].
  3. Mark the All records must meet specified criteria checkbox. 
In some situations, you would need to use two queries to get this information. For example, let's say you have appeal codes for each year: Annual Appeal 2002, Annual Appeal 2003, Annual Appeal 2004, and Annual Appeal 2005. You also have multiple appeals in honor of your 100th anniversary: Gala Dinner, Fun Run, and Open House. You want to find the constituents who gave to one of the annual appeals and also gave in honor of your 100 year anniversary. Because you are looking for donors who gave to at least one appeal in two different groups of appeals, you would need two queries. In this situation, do the following:
  1. Create a constituent query (Query A) and filter on Gift, Appeal ID one of [the first set of appeals].
  2. Create a constituent query (Query B) and filter on Gift, Appeal ID one of [the second set of appeals].
  3. Merge Query A and Query B using the AND operator. The order of the queries does not matter.
     

In the example above, the criteria would be:

  1. Create a constituent query (Query A) and filter on Gift, Appeal ID one of Annual Appeal 2002, Annual Appeal 2003, Annual Appeal 2004, Annual Appeal 2005.
  2. Create a constituent query (Query B) and filter on Gift, Appeal ID one of Gala Dinner, Fun Run, Open House.
  3. Merge Query A and Query B using the AND operator. The order of the queries does not matter.