connectives

connectives


col-hdr-supp Index Level converting-nulls
Syntax
Category Access
Type Definition
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.
Options
See Also modifiers options: logical connectives le before not account after ge and
Example
Warnings
Compatibility D3 7.0 AP R83
col-hdr-supp Index Level converting-nulls