- Click Query>New Query
- Select Gift from the Query type drop-down
- Select Static or Dynamic from the Query format drop-down
- Click OK
- Click File>Save
- Name the query Query #1
- Click Save
- Close the query
- Click Query>New Query
- Select Gift from the Query type drop-down
- Select Static or Dynamic from the Query format drop-down
- Click OK
- On the Criteria tab, select Gift Information>Finder Number
- Change the Operator to not blank
- Click Run Now
- Click File>Save
- Name the query Query #2
- Click Save
- Close the query
- Click Query>Merge Queries...
- Click the binoculars icon in the Primary Query field
- Search for Query #1 (saved in step 6)
- Click Open
- Click the binoculars icon in the Secondary Query field
- Search for Query #2 (saved in step 17)
- Click Open
- Select Sub from the Merge Operator drop-down
- Click OK
- Select your desired fields on the Output tab of the merged query
- Click Run Now
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.