Microsoft Office Tutorials and References
In Depth Information
Filtering by single and multiple combinations of choices
Add a second set of criteria
The following table provides examples of using symbols in criteria
to alter how data is matched.
(continued)
Symbol
Example
Description
*
Like ‘*John’ or Like ‘John*’
or Like ‘*John*’
Wildcard searching in text fields. You do not need to type Like.
#
#01/10/2012#
Matches a date. You do not need to type the pound (#) symbol.
BETWEEN
BETWEEN 1 and 4
BETWEEN #01/10/2012#
AND #05/10/2012#
Number or date range comparison. Includes the first and last criteria.
IN
IN(1,22,44,55)
IN(‘France’,’USA’)
Set of data values.
<>, >, <,
<=, >=,!=
> 25
<> ‘France’
General and arithmetic comparison; <> and != both mean not equal to.
[?]
Like ‘Fr[?]’
Would match Fra, FrB, frC
Character pattern matching. Match any character (numbers and letters).
Different from * in that [?] will include only records with only one
character after ‘Fr’. That is, it wouldn’t return ‘France’.
[#]
Like ‘000[#]’
Would match 0001, 0002…
Character pattern match (0–9) for a single character.
[A-Z]
Like ‘DNA[A-Z]’
Would match DNAA,
dnaB…
Character pattern match (A–Z) for a single character.
Search JabSto ::




Custom Search