• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Sorting, Finding, and Filteri... > Finding Matching Records in a Table

Finding Matching Records in a Table

To search for and select records with field values that match (or partially match) a particular value, use Access's Find feature. To find Lulå (a relatively large city in northern Sweden close to the Arctic Circle) in the City field, follow these steps:

  1. In the Customers table, select the field (City) you want to search by clicking its header button or by placing the caret in the field.

  2. Click the toolbar's Find button or choose Find from the Edit menu to display the Find and Replace dialog (see Figure 6.4). You can also display this dialog by pressing Ctrl+F. The dialog opens with the Find page active by default.

    Figure 6.4. The opened Find in Field dialog with the City field selected.

  3. Type the name of the city (Lulea) in the Find What text box (see Figure 6.5). Making an entry in the Find What text box enables the Find Next command button.

  4. Select Whole Field from the Match drop-down list. (The other choices, Start of Field and Any Part of Field, are just as effective in this case.)

    The default value of the Search option button is satisfactory, and matching case or format is not important here.

  5. Click the Find Next button. If you don't have a Scandinavian keyboard, Access displays the message box shown in Figure 6.6.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint