First, we'll need to create a starting query of all largest transactions within the database. This example will look for largest transaction received: 
  1. Click Queries
  2. Select a category that you want to store this query in
  3. Select New Query under the tasks menu
  4. Name the query All Largest Transactions Received
  5. Set the Starting criteria to Base/All Constituents
  6. Set the Data Return Type to Journal Entries
  7. Under Criteria Matching select Match Each Criteria
  8. Select Amounts  from the Available Fields drop down menu and click on Largest Transaction
  9. Select Received
  10. Click Save and View Queries

Then for each desired range, the query created above will be the starting query. Continuing the example for largest transaction received, let's create queries for largest transactions in the ranges of $0.01 to $499.99, $500 to $999.99, and $1000 and higher.
  1. Click Queries
  2. Select a category that you want to store this query in
  3. Select New Query under the tasks menu
  4. Name the query All Largest Transactions Received $0.01 to $499.99
  5. Set the Starting criteria to query created above
  6. Set the Data Return Type to Journal Entries
  7. Under Criteria Matching select Match Each Criteria
  8. Select Commonly Used Fields from the Available Fields drop down menu and click on Individual Transaction Received
  9. Set the field to greater than or equal to $0.01
  10. Set the Optional Comparison to less than or equal to $499.99
  11. Add any other desired fields
  12. Click Save and View Queries
  13. Locate the All Largest Transactions Received $0.01 to $499.99 query and click Copy
  14. Name the query All Largest Transactions Received $500 to $999.99
  15. Edit the Individual Transaction Received Amounts: $0.01 to $500 (still greater than or equal to) and $499.99 to $999.99 (Optional Comparison still less than or equal to)
  16. Click Save and View Queries
  17. Locate the All Largest Transactions Received $0.01 to $499.99 query and click Copy
  18. Name the query All Largest Transactions Received $1000+
  19. Edit the Individual Transaction Received Amount: $0.01 to $1000.00 (still greater than or equal to)
  20. Change the Optional Comparison to (None Selected) and delete the amount beside it
  21. Click Save and View Queries
  22. The result should be three queries as follows.
  • All Largest Transactions Received $0.01 to $499.99
  • All Largest Transactions Received $500 to $999.99
  • All Largest Transactions Received $1000+