Parameter Queries?

[lou]

How would I run a parameter query that prompts you to type the first
couple letters of a last name, and will allow the entire name to be
retrieved?

 

[Rick Brandt]

How would I run a parameter query that prompts you to type the first
couple letters of a last name, and will allow the entire name to be
retrieved?

SELECT FieldName
FROM TableName
WHERE FieldName Like [Enter Characters] & "*"

 

[John Vinson]

How would I run a parameter query that prompts you to type the first
couple letters of a last name, and will allow the entire name to be
retrieved?

Use a criterion such as

LIKE [Enter start of last name:] & "*"

or, better, use an unbound Form frmCrit with a textbox txtSearch and

LIKE [Forms]![frmCrit]![txtSearch] & "*"

John W. Vinson[MVP]