Microsoft Office Tutorials and References
In Depth Information
Criteria that use text also can make use of two wildcard characters: An asterisk (*) matches any number of char-
acters; a question mark (?) matches any single character.
Table 9-3 shows examples of criteria that use text. Some of these are a bit counterintuitive. For example, to se-
lect records that match a single character, you must enter the criterion as a formula (refer to the last entry in the
table).
Table 9-3: Examples of Text Criteria
Criteria
Selects
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"
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 .
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
="=s*s"
<>*c
Records that contain text that does not end with the letter C.
=????
Records that contain exactly four characters.
<>?????
All records that don't contain exactly five characters.
<>*c*
Records that do not contain the letter C.
Records that contain text that begins with a single question mark character.
(The tilde character overrides the wildcard question mark character.)
~?
Search JabSto ::




Custom Search