Using Prompt with a "like" query parameter

R

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
 
F

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
Click to expand...

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

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
Click to expand...

Like "*" & [Search for who?] & "*"
Click to expand...

Thanks Fred- it worked like a charm

rpm
 
Top