Parameter Queries?

  • Thread starter Thread starter lou
  • Start date Start date
L

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?
 
lou said:
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?
Click to expand...

SELECT FieldName
FROM TableName
WHERE FieldName Like [Enter Characters] & "*"
 
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?
Click to expand...

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]
 
Back
Top