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

Chapter 7. 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 Luleå (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 cursor in that field.

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

Figure 7.4. The Find and Replace dialog opens with the name of the selected field in the Look In list of the Find page. The Find Next button is disabled until you type an entry in the Find What text box.


3.
Type the name of the city (Lulea) in the Find What text box (see Figure 7.5). The Find Next command button is enabled. The default values of the Match and Search lists are satisfactory at this point. Matching case or format is not important here, so clear the Search Fields As Formatted check box.

Figure 7.5. A Whole Field match is selected by default, so type the entire value (Lulea for this example) to find in the Find What text box.


4.
Click the Find Next button. If you don’t have a Scandinavian keyboard, Access displays the message box shown in Figure 7.6. Click OK to dismiss the message box.

Figure 7.6. If the Find feature doesn’t find a match for your entry, you receive a “not found” message.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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