access.connectives Definition/Access: Verbs

access.connectives

Command access.connectives Definition/Access: Verbs
Applicable release versions: AP, R83
Category Access: Verbs (152)
Description words in a master dictionary which are used to form the elements of Access statements.

Relational operators are used to establish criteria based on the relationship of data to fixed values or other data.

Relational operators are used, for example, to select a range of zip code values within specified upper and lower limits. This can be done using "gt" and "lt" as well as the "and" relational operators to establish the selection criteria.

"#" or "ne"
test for a "not equal" condition.

"&" or "and"
used between two conditions to indicate they both must be true.

"<" or "lt" or "before"
tests for a less than condition.

"<=" or "le"
tests for a "less than or equal to" condition.

"=" or "eq"
tests for an "equal" condition.

">" or "gt" or "after"
tests for a "greater than" condition.

">=" or "ge"
tests for a "greater than or equal to" condition.

"not" or "no"
tests a negative condition, reversing a true relation.

"or"
is used between two conditions to indicate one or the other must be true.
Syntax
Options
Example
Purpose
Related access.modifiers
access.options
access.logical.connectives
access.le
access.before
access.not
account
access.after
access.ge
access.and