Using a wildcard with a parameters query (not a combo box)

[Guest]

I have built the parameter query and now would like to be able to search the
DB by using a wildcard in the form made with the parameters query. (i.e.
search using “Mi†and not “Mikeâ€) is this a possibility?

 

[Guest]

Hi,
Are you using the regular input box to provide the parameter or are you
hardcoding the value in the crieria area of the query. If you use an input
box then try:

Like [Enter Value:] & "*"

Or if hardcoded then:

"Mi*"

HTH
Good luck

 

[Guest]

Thanks!

Hi,
Are you using the regular input box to provide the parameter or are you
hardcoding the value in the crieria area of the query. If you use an input
box then try:

Like [Enter Value:] & "*"

Or if hardcoded then:

"Mi*"

HTH
Good luck
--
Oli-S
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de

I have built the parameter query and now would like to be able to search the
DB by using a wildcard in the form made with the parameters query. (i.e.
search using “Mi†and not “Mikeâ€) is this a possibility?