Using Prompt with a "like" query parameter

[rpm]

Is there a way to create a query that will allow me to enter a "like"
search for any text with a prompt command?

For example I am want to view all last names with the text Smith
anywhere in the field. Fields are First Name, Last Name

In the design view the query criteria in the Last Name field would be
normally be- Like "*Smith*"

Can I create a parameter prompt that will allow me to do the search for
all last names that have the word Smith in them?

rpm

 

[fredg]

Is there a way to create a query that will allow me to enter a "like"
search for any text with a prompt command?

For example I am want to view all last names with the text Smith
anywhere in the field. Fields are First Name, Last Name

In the design view the query criteria in the Last Name field would be
normally be- Like "*Smith*"

Can I create a parameter prompt that will allow me to do the search for
all last names that have the word Smith in them?

rpm

Like "*" & [Search for who?] & "*"

 

[rpm]

Is there a way to create a query that will allow me to enter a "like"
search for any text with a prompt command?

For example I am want to view all last names with the text Smith
anywhere in the field. Fields are First Name, Last Name

In the design view the query criteria in the Last Name field would be
normally be- Like "*Smith*"

Can I create a parameter prompt that will allow me to do the search for
all last names that have the word Smith in them?

rpm

Like "*" & [Search for who?] & "*"

Thanks Fred- it worked like a charm

rpm