To exclude constituents with a specific constituency code from the query:

 
       
    • On the Criteria tab, select Constituency, Constituency code does not equal [the constituent code to exclude]



    Note: To exclude multiple constituency codes, use the 'not one of' operator instead of 'does not equal'.

     

    To find constituents with a specific constituency code but exclude those that have another specific constituency code:


    For example, to find all parents but is not a board member (e.g. all constituents with a constituent code of parent that does not have a constituent code of board member).
       
      • Create a constituency query (Query A). On the Criteria tab, select Constituency, Constituency code equals [the constituency code to include].
      • Create a constituent query (Query B). On the Criteria tab, select Constituency, Constituency code equals [the constituency codes to exclude].
      • Merge Query A and Query B using the SUB merge operator with Query A as the primary and Query B as the secondary.
       

       



      In the example above (parents that are not board members):