/en/access2000/sorting-multiple-records/content/
When you are dealing with a large database filled with thousands of records, you may need to quickly locate one of them. Access provides an easy way to find individual records: the Find function.
If you've already clicked in the field that contains the data you're searching for, you can skip this step.
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.
Wild card | Usage | Example |
*(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. |
OR
/en/access2000/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.