- Create a constituent query for the main group of records needed (Query A)
- Create a second query for all of the records that need removed from the first group in Step 1 (Query B)
- Merge queries with Query A as the Primary Query and Query B as the Secondary Query
- Select the SUB operator
Use Query List to remove specific constituent(s) from the query
Note: Both options will produce Static queries.