O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required