/en/accessxp/sorting-records/content/
When you have an extremely large database consisting of thousands of records, you may need to quickly locate one of them. Access provides an easy way to find individual records: the Find function.
OR
If Access did not find a match for the search, the Office Assistant will pop up to inform you that there were not any matched records found.
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.
Wild Card | Usage | Example |
* | 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. |
OR
/en/accessxp/filtering-records/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.