Microsoft Office Tutorials and References
In Depth Information
Searching a Database
Table 17-1
Common Criteria for Filtering
Different Types of Data
Field Data Type
Filtering Criteria
Description
Text
Equals
Field must match filter text
exactly.
Does Not Equal
Field must not match filter text.
Begins With
Field must start with the filter
text.
Does Not Begin
With
Field must not begin with the
filter text.
Contains
Field must contain the filter text.
Does Not Contain
Field must not contain any part of
the filter text.
Ends With
Field ends with the filter text.
Does Not End With
Field does not end with the filter
text.
Numbers
Equals
Field must equal filter number.
Does Not Equal
Field must not equal filter
number.
Less Than or
Equal To
Field must contain a number less
than or equal to the filter number.
Greater Than or
Equal To
Field must contain a number
greater than or equal to the filter
number.
Between
Field must contain a number that
falls between two filter numbers.
Dates
Equals
Field must equal the filter date.
Does Not Equal
Field must not equal the filter
date.
On or Before
Field date must be equal or
earlier than the filter date.
On or After
Field date must be equal or later
than the filter date.
To create the filter criteria, follow these steps:
1. In the All Tables pane on the left of the screen, double-click the name
of the database table you want to filter.
Access displays the Datasheet view of your database.
 
Search JabSto ::




Custom Search