Parameter Queries - Include rather than exact

[templeowls]

When setting up a parameter query, is there a way for the query to show data that "includes" the words rather it being an "exact" match? For example, I want to set up a parameter query for the "name" column but this column has first and last name. I want to set it up so if you type john, it will show both people with the first name "John" and last name "Johnson"

[pbaldy]

Use Like and wild cards. With a form textbox a criteria of:

Like "*" & Forms!FormName.TextboxName & "*"

[templeowls]

Do you mind explaining a bit further? I'm not sure exactly what that means. Right now in the Design View of the query, I have [Enter Employee Name:] in the criteria cell of the "employee name" column. So, I have to type the employee name exactly as it is in the table. I'd like to have the ability to type just the first name, last name, or possibly a portion of the last name if possible.

Also, not sure if it matters, but this query is pulling from my table. I'm not using a form for this.

[pbaldy]

Your criteria becomes:

Like "*" & [Enter...] & "*"