access.logical.connectives Modifier/Access: Verbs

access.logical.connectives

Command access.logical.connectives Modifier/Access: Verbs
Applicable release versions: AP, R83
Category Access: Verbs (152)
Description 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.
Syntax
Options
Example
Purpose
Related access.connectives
access.with
access.or
access.and
access.sellist