access.connectives

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.