To find accounts without donations we first want to find accounts with donations.  Then subtract those from the standard All Constituents query. This will leave us with the non-donors in the database.

First, find the donors:
  1. Click Queries
  2. Click Manage Queries
  3. Click a category to store this query in.  (ex. Base)
  4. Click New Query under the Tasks menu
  5. Name the query Donors
  6. Set the Starting Query to Base: All Constituents
  7. Under Results, set the Data Return Type to Accounts
  8. Under Criteria Options mark Match At Least One Criteria
  9. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Journal Entry Types
  10. Mark Recurring Gift, Pledge, Recurring Gift Schedule, Upgraded Pledge, Gift, Payment, Split Transaction, and Purchase
  11. Click Save And - View Queries
Note: Some organizations may have constituents with a Pledge, but have never made a payment. The query above would consider them a donor. If we just wanted to find anyone that has given the organization a Received Amount, select Individual Transaction Received in step 9 instead of Journal Entry Types.  Then fill in Individual Transaction Received to Greater Than Or Equal To $0.01. This way the query would find those that have made a physical contribution.

Second, we will use a Compound Query to subtract Donors from the standard All Constituents query
  1. Click Queries
  2. Click Manage Queries
  3. Select a category to store this query in (Ex: Base)
  4. Click New Compound Query under the Tasks menu
  5. Name the query Non-Donors
  6. Under Results set the Data Return Type to Accounts
  7. Under How would you like the results of each query to interact?, select Subtract Query 2 from Query 1
  8. Set Query 1 to  Base: All Constituents - A
  9. Set Query 2 to  the category you built your All Donors query: All Donors - A
  10. Click Save And - Preview