Microsoft Office Tutorials and References
In Depth Information
Specifying Advanced Filter Criteria
Table 9-3: Examples of Text Criteria
Criteria
Selects
=“=January”
Records that contain the text January (and nothing else). You enter this exactly as shown:
as a formula, with an initial equal sign. Alternatively, you can use a leading apostrophe and
omit the quotes:
‘=January
January
Records that begin with the text January.
C
Records that contain text that begins with the letter C.
<>C*
Records that contain any text, except text that begins with the letter C.
>=L
Records that contain text that begins with the letters L through Z.
*County*
Records that contain text that includes the word county.
Sm*
Records that contain text that begins with the letters SM.
s*s
Records that contain text that begins with S and has a subsequent occurrence of the letter S.
s?s
Records that contain text that begins with S and has another S as its third character. Note
that this does not select only three-character words.
=”=s*s”
Records that contain text that begins and ends with S. You enter this exactly as shown: as
a formula, with an initial equal sign. Alternatively, you can use a leading apostrophe and
omit the quotes:
‘=s*s
<>*c
Records that contain text that does not end with the letter C.
=????
Records that contain exactly four letters.
<>?????
All records that don’t contain exactly five letters.
<>*c*
Records that do not contain the letter C.
~?
Records that contain a single question mark character. (The tilde character overrides the
wildcard question mark character.)
=
Records that contain a blank.
<>
Records that contain any nonblank entry.
=”=c”
Records that contain the single character C. You enter this exactly as shown: as a formula, with
an initial equal sign. Alternatively, you can use a leading apostrophe and omit the quotes:
‘=c
Specifying multiple criteria
Often, you may want to select records based on criteria that use more than one field or multiple
values within a single field. These selection criteria involve logical OR or AND comparisons.
Following are a few examples of the types of multiple criteria that you can apply to the real
estate database:
h A list price less than $250,000, and square footage of at least 2,000
h A single-family home with a pool
 
Search JabSto ::




Custom Search