• 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 in the City field Luleå (a relatively large city in northern Sweden close to the Arctic Circle), follow these steps:

1.
Select the field—City—you want to search by clicking its header button or placing the caret in the field.

2.

Click the toolbar's Find button or choose Edit, Find to display the Find in field dialog shown in Figure 6.4. You can also display this dialog by pressing Ctrl+F.

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 First and Find Next command buttons.

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 First button. If you do not have a Scandinavian keyboard, Access displays the "finished searching" 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