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?