Microsoft Office Tutorials and References
In Depth Information
Filtering Data Lists
Table 11-2
Operators Used in Custom AutoFilters
Operator
Example
What It Locates in the
Database
Equals
Salary equals 35000
Records where the value
in the Salary field is equal
to $35,000
Does not equal
State does not equal NY
Records where the entry
in the State field is not NY
(New York)
Is greater than
Zip is greater than 42500
Records where the
number in the Zip field
comes after 42500
Is greater than or
equal to
Zip is greater than or equal
to 42500
Records where the
number in the Zip field is
equal to 42500 or comes
after it
Is less than
Salary is less than 25000
Records where the value
in the Salary field is less
than $25,000 a year
Is less than or
equal to
Salary is less than or equal
to 25000
Records where the value
in the Salary field is equal
to $25,000 or less than
$25,000
Begins with
Begins with d
Records with specified
fields have entries that
start with the letter d
Does not begin
with
Does not begin with d
Records with specified
fields have entries that do
not start with the letter d
Ends with
Ends with ey
Records whose specified
fields have entries that
end with the letters ey
Does not end
with
Does not end with ey
Records with specified
fields have entries that do
not end with the letters ey
Contains
Contains Harvey
Records with specified
fields have entries that
contain the name Harvey
Does not contain
Does not contain Harvey
Records with specified
fields have entries that
don’t contain the name
Harvey
Search JabSto ::




Custom Search