Wild card searches

Wild cards in a search are characters that will match any character in the field. You can use them where you're trying to find something like 'a code that starts with 'S' and includes an 'x''.

Wild cards

Access supports two wild card characters:

? matches any single character.

* matches any number of characters - including none.

Just type these characters as part of the expression you're searching for.

Examples

a?e Matches 'are', 'database', 'A/e',
8?7 Matches '1817', '8a7', and 'B48 7PQ' - remember that a space counts as a character.
a*e Matches 'Alvechurch', 'database', and 'Mary had a little lamb' because * matches any number of characters - including one.
8*7 Matches 'SER#83/3471a', '1817', and '87' because * matches any number of characters - including none.