access.logical.connectives

a brief discussion of the boolean operators 'and' and 'or' as used in access selection clauses.

Logical connectives are boolean operators used to connect two or more selection criteria clauses in an Access sentence.

When two clauses are connected with an 'or', either clause may be true for data to be selected for processing:

... with city 'richmond' or with state 'ca'

When an 'and' clause connects two clauses, both clauses have to be true for data to be affected:

... with city 'richmond' and with state 'ca'

When the connective between two clauses is omitted, the default connective is an 'or':

... with city 'richmond' with state 'ca'

The 'and' clauses take precedence over 'or' clauses, and a maximum of nine 'and' clauses may be specified.