Special Edition Using Access 97, Second Edition

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.