The tools above the Include Records Where section are called combining operators. With combining operators, you can combine two or more separate filter criteria to narrow your query even further. Combining operators are characters that provide a link between selected criteria and help to define the records included in the query.
User-added image
 
Combining OperatorDescriptionExample Results
 
and
Indicates that records must meet both criteria to be selected.City Equal to Charleston
and
State Equal to South Carolina:
Only records with a city of Charleston and a state of South Carolina are included. Records with a city of Charleston and a state of West Virginia are excluded. Records with a city of Greenville and a state of South Carolina are also excluded. Both criteria must be met.
 
or
Indicates that records can meet either criteria to be selected.City Equal to Charleston
or
State Equal to South Carolina:
All records that have a city of Charleston will be included regardless of what state and all records that have a state of South Carolina will be included regardless of the city. All of the following would be included:
Charleston, SC
Charleston, WV
Greenville, SC
Columbia, SC
 
Parentheses ( )
Indicates the order in which criteria should be evaluated; combines two or more criteria together to be considered as a single filter.
This is similar to how parentheses work in math. Parentheses in different locations in the same equation give different results:
(2+3)x6 =30
2+(3x6)=20
Parentheses should be used whenever there are three or more filters and a mix of and and or combining operators.
State Equal to South Carolina
and
(City Equal to Charleston
or
City Equal to Columbia)
Records in either Charleston, South Carolina or Columbia, South Carolina.
 
(State Equal to South Carolina
and
City Equal to Charleston)
or
City Equal to Columbia
Records with a city of Charleston and a state of South Carolina are included as well as records with a city of Columbia regardless of the state are selected.
Note: Without parentheses, criteria are evaluated from top to bottom.