Microsoft Office Tutorials and References
In Depth Information
Understanding Microsoft Query
Chapter 8: Querying Data Sources
Query Criteria
You can specify the filtering portion of a
database query by specifying one or more
criteria . These are usually logical expressions
that, when applied to each record in the
query’s underlying table, return either a true or
false result. Every record that returns a true
result is included in the query, and every
record that returns a false result is filtered out
of the query. For example, if you only want to
work with records where the Country field is
equal to USA, then you can set up criteria to
handle this, and the query discards all records
where the Country field is not equal to USA.
r
Ano ther Field
no ther Fi ld
n o t h e r F
Ano
er Field
r Field
10
Criteria Operators
The following table lists the operators you can use to build your criteria expressions:
Excel’s Criteria Operators
Operator
Value in the Field
Equals (=)
Is equal to a specified value.
Does not equal (<>)
Is not equal to a specified value.
Is greater than (>)
Is greater than a specified value.
Is greater than or equal to (
=)
Is greater than or equal to a specified value.
Is less than (<)
Is less than a specified value.
Is less than or equal to (
=)
Is less than or equal to a specified value.
Is one of
Is included in a group of values.
Is not one of
Is not included in a group of values.
Is between
Is between (and including) one value and another.
Is not between
Is not between (and does not include) one value and another.
Begins with
Begins with the specified characters.
Does not begin with
Does not begin with the specified characters.
Ends with
Ends with the specified characters.
Does not end with
Does not end with the specified characters.
Contains
Contains the specified characters.
Does not contain
Does not contain the specified characters.
Like
Matches a specified pattern.
Not like
Does not match a specified pattern.
Is Null
Is empty.
Is Not Null
Is not empty.
 
Search JabSto ::




Custom Search