The first query will find all donations within the date range you want to focus on; in this example, we will focus on donations made in 2015. The second query will, then, find donors who gave a certain number of times within that date range; in this case, we will look for donors who gave 3 or more times in 2015.

First we create a query to find all donations in 2015:
  1. Click the Queries button on the menu bar
  2. Click Manage Queries
  3. Select a category that you want to store this query in (Ex: Base)
  4. Click New Query under the Tasks menu
  5. Name the query “All donations in 2015”
  6. Set the Starting Query to Base: All Constituents – A
  7. Set the Data Return Type to Journal Entries
  8. Select Match Each Criteria under the Criteria Matching field
  9. Select Commonly Used Fields from the Browse Fields drop down menu and click Journal Entry Date
  10. Fill in 1/1/2015-12/31/2015
  11. Select Commonly Used Fields from the Browse Fields drop down menu and click Individual Transaction Received
  12. Fill in Greater Than or Equal To 1
  13. Click Save And – Preview
     
B. Next we will create a query to find donors who gave 3 or more times in 2015:
  1. Click the Queries button on the menu bar
  2. Click Manage Queries
  3. Select a category that you want to store this query in (Ex: Base)
  4. Click New Query under the Tasks menu
  5. Name the query “Donors who gave 3+ donations in 2015”
  6. Set the Starting Query to “All donations in 2015,” the query we created in Step A
  7. Set the Data Return Type to Journal Entries
  8. Select Match Each Criteria under the Criteria Matching field
  9. Select Cumulative Amounts from the Browse Fields drop down menu and click Cumulative Number Transactions
  10. Fill in Greater Than or Equal To 3
  11. Click Save And – Preview

The query in Step B will return donations in 2015 from donors who gave 3 or more times.

After you complete the queries you may wish to create a report that displays the number of transactions each donor made in that date range. For steps on how to create a report displaying the number of transactions per donor, see How do I report on number of transactions per donor?.

Please note that this same process can also be used to find donors who have given a specific number of times to a Campaign/Approach/Fund. For example, you may want to locate donors who have given 2 or more times to your Annual Fund. In that case, the first query would find all donations to the Annual Fund, while the second query would find donors who gave 2 or more times. The first query will always find donations that meet all other criteria except the cumulative criteria (date range, fund, campaign, etc...), while the second query will always use the cumulative criteria to find those that gave with the frequency you want to focus on.