If you are unable to find the record you're searching for using a simple find, try typing an operator in the Find What text box in the Find and Replace dialog box. A common Access operator is a wild card, or a symbol representing one or more characters.
|*(Asterisk)||Used at the beginning or the end of a search string to match one or more characters||Sch* finds Schlotz and Schwartz. *ing finds Wheeling and Browning.|
|? (Question Mark)||Matches any single alphabetic character||Sp?ll finds spell and spill.|
|# (Pound Sign)||Matches any single numeric character||9#1 finds 901, 911, 921, 931, etc.|