Article ID: 294954 - View products that this article applies to.
This article was previously published under Q294954
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 97 version of this article, see 88671For a Microsoft Access 2000 version of this article, see 209823
This article shows you how to create a parameter query to search for all the records in a table that begin with, or that contain, a certain letter.
An easy way to search for records that begin with a certain letter is to create a parameter query that prompts for a character to search for. You can use the LIKE operator with the wildcard character (*) to accomplish this task. This example uses the Employees table in the sample database Northwind.mdb.
Method to Create Parameter Query Using the LIKE Operator
For more information about parameter queries, click Microsoft Access Help on the Help menu, type parameter query in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.