Validation and Selection Criteria are both used to ensure that data meets the requirements of an expression. Validation is used when first entering the data into the data base. Selection Criteria is used when filtering data already in a database.

<
Less than
<=
Less than or equal to
>
Greater than
>=
Greater than or equal to
=
Equal to
<>
Not equal to
IN
Test for "equal to" any member in a list enclosed in parentheses
BETWEEN
Test for "equal to" within a range of values, a low and a high value separated by the AND operator, eg BETWEEN 10 AND 20.
LIKE
Test for match with a pattern string.
AND
Yields true if its both of its arguments are true
OR
Yields true if either of its arguments are true
NOT
Converts its argument to its logical opposite, eg this expression will return as False: NOT True.
" "
Encloses a string, pattern string, or segment of a pattern string
# #
Encloses date and or time values expressed in a standard format. Internally, the dates and times are stored as double-precision floating point numbers where the integer portion represents the day and the fractional portion represents the fraction of a day.
?
Any single character
*
Zero or more characters
#
Any single digit
[ ]
Encloses a list of valid characters
-
Indicates a range of characters
!
Indicates characters to not match


GeorgeHernandez.comSome rights reserved