New to Query? Check out Getting Started with Query (PDF) to understand basic concepts and create your first query—all in a matter of minutes!

For a list of constituents use a constituent query, for a list of gifts (including gift amounts) use a gift query.

To query on constituents who gave a single gift greater than, less than, or equal to a specific amount:

  1. Create a Gift query.
  2. On the Criteria tab, select Gifts, Gift Amount.
  3. Select the appropriate operator, depending on what you want to find. For example, if querying on constituents who gave gifts over a specific amount, select greater than [amount].


To query on constituents who gave a single gift over a specific amount in a specific date range:

  1. Create a Gift query.
  2. On the Criteria tab, select:
    Gifts, Gift Amount greater than or equal to [the amount]
    AND Gifts, Gift Date between [date range] 


For total giving over a specific amount in a date range:

Refer to How to query on constituents' total giving within a date range (includes demo).