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