perameter query

[cschless]

I have set up a name search query with a perameter box.
However, the query will only work when I enter the full
name that is listed in the field eg John Smith, where as I
would like to search all Johns' or all Smiths'. ie search
Smith and have returns of all the smiths on the database.
How can I do this?

 

[Rick B]

like "*" & [EnterPartialName] & "*"

 

[fredg]

I have set up a name search query with a perameter box.
However, the query will only work when I enter the full
name that is listed in the field eg John Smith, where as I
would like to search all Johns' or all Smiths'. ie search
Smith and have returns of all the smiths on the database.
How can I do this?

To return the entered name anywhere in the field:
Like "*" & [Enter Name] & "*"

To return the entered name at the beginning of the field:
Like [Enter Name] & "*"

To return the entered name at the end of the field:
Like "*" & [Enter Name]