Yes, as long as they are on different fields.

 

For example:

 

Correct query filters:

 

Constituency, Constituency Code equals Board Member

AND Solicit Codes, Solicit Code Description does not equal Do not mail

 
 

The query pulls everyone who has a constituency code of Board member and who does not have a solicit code of Do not mail.

 

Incorrect query filters:

 

Constituency, Constituency Code equals Board Member

AND Constituency, Constituency Code does not equal Alumni

 
 

The query pulls everyone who has a constituency code of Board Member. It does not exclude constituents who also have a constituency code of Alumni.

 

When the same field is used in query multiple times it looks at the same value. The query criteria in the above example is asking query to find a constituent with a constituency code of Board Member whose constituency code of Board Member does not equal Alumni. All constituency codes of Board Member do not equal Alumni, so this criteria filter does not do anything in the query.

 

If you want to pull everyone with a constituency code of Board Member that does not have another constituency code of Alumni, create two queries and merge them:

 
       
    • On the Criteria tab, select Constituency, Constituency Code equals Board Member.
    .  
    • On the Criteria tab, select Constituency, Constituency Code does not equal Alumni.
     
    • Merge the queries using the SUB operator with Query A as primary and Query B as secondary.