Query Criteria: Excluding vs. Include and All vs. Any

Each query criteria set, contains an introductory sentence Include data where all of the following are true.

 

1. The word Include can be clicked on to change it to Exclude.

 

• To display all accounts that pledged to campaign DINR2014, the introductory sentence before filtering the criteria would read:

Include data where all of the following are true

 

• To display all accounts that did not pledge to campaign DINR2014, the introductory sentence before filtering the criteria would read:

Exclude data where all of the following are true.

 

2. The word all can be clicked on to change it to any.

 

• To display all accounts that pledged to the campaign DINR2014 AND have the association of BOARD, the introductory sentence before filtering the criteria would read:

Include data where all of the following are true.

 

• To display all accounts that pledged to the campaign DINR2014 OR have the association of BOARD, the introductory sentence before filtering the criteria would read:

Include data where any of the following are true.