First, find the donors:
- Click Queries
- Click Manage Queries
- Click a category to store this query in. (ex. Base)
- Click New Query under the Tasks menu
- Name the query Donors
- Set the Starting Query to Base: All Constituents
- Under Results, set the Data Return Type to Accounts
- Under Criteria Options mark Match At Least One Criteria
- Under Browse Fields select Commonly Used Fields from the drop down menu and click on Journal Entry Types
- Mark Recurring Gift, Pledge, Recurring Gift Schedule, Upgraded Pledge, Gift, Payment, Split Transaction, and Purchase
- Click Save And - View Queries
Second, we will use a Compound Query to subtract Donors from the standard All Constituents query
- Click Queries
- Click Manage Queries
- Select a category to store this query in (Ex: Base)
- Click New Compound Query under the Tasks menu
- Name the query Non-Donors
- Under Results set the Data Return Type to Accounts
- Under How would you like the results of each query to interact?, select Subtract Query 2 from Query 1
- Set Query 1 to Base: All Constituents - A
- Set Query 2 to the category you built your All Donors query: All Donors - A
- Click Save And - Preview