1. Create a constituent query
  2. On the Criteria tab, select:

    Summary Information*, Summary for Gift, Total Number of Gifts greater than or equal to [the minimum number of gifts given during one year]. On the Filters tab, select:
    Gift Information, Gift Date between [date range for one year]

    AND Summary Information*, Summary for Gift, Total Number of Gifts greater than or equal to [the minimum number of gifts given during one year]. On the Filters tab, select:
    Gift Information, Gift Date between [date range for another year]

    Note: For each year during which the constituent should have given the minimum number of gifts, add another Summary Information filter.

* For more information on selecting and filtering Summary Information fields in query, refer to BB237530.
 

For example, to query on constituents who have given at least two gifts every year between 2004 and 2005, follow these steps:

  1. Create a constituent query
  2. On the Criteria tab, select:

    Summary Information, Summary for Gift, Total Number of Gifts greater than or equal to 2. On the Filters tab, select:
    Gift Information, Gift Date between 1/2/2004 and 12/31/2004

    AND Summary Information, Summary for Gift, Total Number of Gifts greater than or equal to 2. On the Filters tab, select:
    Gift Information, Gift Date between 1/1/2005 and 12/31/2005