Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
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''.
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.
|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.|