You can automatically create this query by installing the sample query.

  1. Create a constituent query
  2. Filter on Summary Information, Summary for Gift, Pledge Balance
    Note: For a summary amount within a specific date range, fund, etc., use the Filter tab on the Edit Field Criteria window 


  1. Create a gift query
  2. Filter on Gift Information, Pledge Balance