Using Prompt with a "like" query parameter

Using Prompt with a "like" query parameter

Post by rpm » Fri, 07 Dec 2007 12:40:11


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
 
 
 

Using Prompt with a "like" query parameter

Post by fred » Fri, 07 Dec 2007 14:15:27


Like "*" & [Search for who?] & "*"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 
 
 

Using Prompt with a "like" query parameter

Post by rpm » Fri, 07 Dec 2007 17:06:39

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



Thanks Fred- it worked like a charm

rpm