Create an Exclusion Query
- Create a single query where we say Membership Status is equal to active. This will be the only criteria of the query. Save this query as a dynamic selection with the box "Show this Selection in the Query Designer" Marked
- Create another query (or return to your orginial incorrect query). On the left in Browse for Fields in > find the yellow folder labeled Selections > Click and highlight > In the middle column in Select Fields find the Exclusion Query that was created > Drag it to Include Records Where > Exists is equal to no. Note: To use exclusion queries successfuly both of the queries must be of the same query source view. You can only exlcude constituents from constituents, memberships from members, etc.
These operators allow you to combine multiple lines of criteria (or filters) in a query. They can add more specifics to the results you're seeing.
|AND||The default combining operator in Query. Records must meet both criteria to be selected.||Membership Status is equal to Active AND ZIP is equal to 29418|
Selects all members who are active and who live in 29418 ZIP code. Jane Smith is the only result. Her membership is active and she lives in 29418.
|OR||Records can meet either criteria to be selected.||Membership Status is equal to Active OR ZIP is equal to 29418|
Selects all members who are active or if they are not a member but live in 29418 ZIP code. For example, Jane Smith is selected because she meets both-- she does not need ZIP of 29418. Mary Jones is also selected for she has an active membership but does not live in 29418.
To learn more about AND or OR operators and How to use Parentheses in query please click here. (BB24257)
Incorrect results could also be because you're not using the correct source view for query. . Click here to learn about which query source view you should use (BB752746).