Microsoft Office Tutorials and References
In Depth Information
Understanding Microsoft Query
Chapter 8: Querying Data Sources
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.
Ano ther Field
no ther Fi ld
n o t h e r F
The following table lists the operators you can use to build your criteria expressions:
Excel’s Criteria Operators
Value in the Field
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 (and including) one value and another.
Is not between
Is not between (and does not include) one value and another.
Begins with the specified characters.
Does not begin with
Does not begin with the specified characters.
Ends with the specified characters.
Does not end with
Does not end with the specified characters.
Contains the specified characters.
Does not contain
Does not contain the specified characters.
Matches a specified pattern.
Does not match a specified pattern.
Is Not Null
Is not empty.