Microsoft Office Tutorials and References
In Depth Information
Limiting Records with Criteria Expressions
Table 1-6 lists the operators that you’re likely to use in an expression that
specifies criteria.
Table 1-6
Using Operators in Criteria
Relational
Operator
What It Does
Finds values equal to text, a number, or date/time. ( Equal to is
understood when you type a criterion without an operator; you
don’t need to type it.)
=
Finds values not equal to text, a number, or date/time.
<>
Finds values less than a given value.
<
<=
Finds values less than or equal to a given value.
>
Finds values greater than a given value.
>=
Finds values greater than or equal to a given value.
BETWEEN
Finds values between or equal to two values.
IN
Finds values or text included in a list.
LIKE
Finds matches for a pattern.
Book III
Chapter 1
When you type your criterion, you don’t have to tell Access the field name.
Just put your criterion in the same column as the field, and Access applies
the criterion to the field that appears in the same column.
Table 1-7 explains how different criteria affect the records that appear
onscreen in the query datasheet.
Table 1-7
Examples of Criteria with Operators
When Field1 Has
This Criterion . . .
You See These Records
<15
Displays records in which Field1 is less than 15 .
<#9/1/03#
Finds records in which Field1 contains a date before
September 1, 2003.
Finds records in which Field1 is greater than 15 .
>15
>#12:00am#
Finds records in which Field1 is a time value after 12
a.m.
>[Max Price]
Finds records in which Field1 is more than the value in
the Max Price field.
(continued)
Search JabSto ::




Custom Search