In Access 2003 finding records may seem confusing at first. This free lesson offers step-by-step instructions.
If the simple Find did not find the record you were looking for, you can try typing an operator in the Find What text box of the Find and Replace dialog box. A common Access operator is a wild card, a symbol representing one or more characters.
|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.|
|Matches any single alphabetic character||Sp?ll finds spell and spill.|
|Matches any single numeric character||9#1 finds 901, 911, 921, etc.|