wilcard search in prompt window

F

fredg

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?]
 
J

johnny_ringo

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...
 
Top