Developer Forum

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?] & "*"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On 2007-12-05 21:15:27 -0800, fredg < XXXX@XXXXX.COM > said:



Thanks Fred- it worked like a charm

rpm