Set up parameter query using wildcards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

barbiegril - 26 Mar 2006 23:56 GMT

Been trying to come up with a way to use a wildcard in a parameter query.
Ex. Parameter query asks for a description, if I enter "tires", would like
the query to pull every record containing the word tire in it.

Reply to this Message

Tom Wickerath - 26 Mar 2006 23:44 GMT

Hi Barbiegril,

Would you settle for entering "tire" to pull every record containing the
word tire in it? If you attempt to enter the plural form, then you would pull
every record with the word tires in it, but no records that included only
tire. However, entering the singular form (tire) would pull records with the
plural form (tires).

Criteria for field of interest: Like "*" & [Enter Keyword] & "*"

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

> Been trying to come up with a way to use a wildcard in a parameter query.
> Ex. Parameter query asks for a description, if I enter "tires", would like
> the query to pull every record containing the word tire in it.

Reply to this Message