- Create an exclusion query
- Click Analysis > Information Library
- Click Add an ad-hoc query
- Choose Constituents as the Source View
- Add the field Constituencies\Constituency to the Include Records Where field:
- Click Constituencies from the Browse for fields in
- Click Constituency from the Select Constituencies fields
- Drag the field to the Include Records Where
- Choose Equal to
- Choose the constituency you want to exclude
- Click OK
- Go to the set save options tab
- Name your query
- Click the box to save as a selection
- Check the box to show in query designer
- Click save
- Create your Query
- Click Analysis > Information Library
- Click Add an ad-hoc query
- Choose Constituents as the Source View
- Add the field Constituencies\Constituency to the Include Records Where field:
- Click Constituencies from the Browse for fields in
- Click Constituency from the Select Constituencies fields
- Drag the field to the Include Records Where
- Choose Equal to (or not equal to if you are trying to exclude)
- Choose the constituency you want to include
- Click OK
- Add the field for the selection of the constituency you want to exclude
- From the left have side expand the selection folder
- From the middle select the exclusion query
- Drag the field to include records where
- Choose is Equal to No
- Save the query
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.