In Access XP finding records may seem confusing at first. This free lesson offers step-by-step instructions.
Using wild cards to find records
If the simple Find did not find the record you sought, 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, or 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.
To search for a record using a wild card:
- Choose EditFind on the menu bar, or click the Find button on the toolbar to open the Find and Replace dialog box.
- In the Find What field, type the wild card combination (e.g., B*) to find the first record where the last name begins with the letter B.
- Click the Find Next button to begin the search. The first record found that matches the search is highlighted.
(The Office Assistant will provide notification if no matching records were found).
- Click the Cancel button if the record was found. The Find and Replace dialog box will close.
- Click the Find Next button to search for the next record that meets the Find criteria.