wilcard search in prompt window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to use a wildcard search in a prompt window for a query
 
i would like to use a wildcard search in a prompt window for a query
Click to expand...

As criteria on the search field:

To find the search value anywhere in the field:
Like "*" & [Search for what?] & "*"

To find the search value only at the beginning of the field:
Like [Search for what?] & "*"

To find the search value only at the end of the field:
Like "*" & [Search for what?]
 
thank you very much!!

fredg said:
i would like to use a wildcard search in a prompt window for a query
Click to expand...

As criteria on the search field:

To find the search value anywhere in the field:
Like "*" & [Search for what?] & "*"

To find the search value only at the beginning of the field:
Like [Search for what?] & "*"

To find the search value only at the end of the field:
Like "*" & [Search for what?]
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save the result of a wildcard search? 1
Partial information queries 2
wildcards in query from form 1
Filename wilcard characters in cmd.exe 4
combine prompt with Like operator? 2
Using Wildcard on Workbooks.Open 1
Use of Wildcard in String Expression 4
Wildcard Search in Text Field 9

Back
Top