Parameter query in which you can search for any word

[Guest]

Hi guys,

I have created a basic parameter query, but when I type in a search term
only the exact match results are returned. Is it possible to change a setting
somewhere so that when i search through the parameter query, the search will
look for anything containing the terms i have entered. For example if i look
for "Knowledge" only results with that specific word are returned but there
are also results with "Knowledge Management" which are not returned. I would
like to be able to type "Kno*" for example and everything beginning with that
and whatever else follows will be returned. Is this possible, and if so, how?

Many thanks,
Rodney

 

[Rick Brandt]

Hi guys,

I have created a basic parameter query, but when I type in a search
term only the exact match results are returned. Is it possible to
change a setting somewhere so that when i search through the
parameter query, the search will look for anything containing the
terms i have entered. For example if i look for "Knowledge" only
results with that specific word are returned but there are also
results with "Knowledge Management" which are not returned. I would
like to be able to type "Kno*" for example and everything beginning
with that and whatever else follows will be returned. Is this
possible, and if so, how?

Many thanks,
Rodney

Replace..

[Your Parameter]

....with...

Like "*" & [Your Parameter] & "*"

 

[Wolfgang Kais]

Hello Rodney.

Hi guys,

I have created a basic parameter query, but when I type in a
search term only the exact match results are returned. Is it
possible to change a setting somewhere so that when i search
through the parameter query, the search will look for anything
containing the terms i have entered. For example if i look for
"Knowledge" only results with that specific word are returned but
there are also results with "Knowledge Management" which are not
returned. I would like to be able to type "Kno*" for example and
everything beginning with that and whatever else follows will be
returned. Is this possible, and if so, how?

Many thanks,
Rodney

Replace the "equals" with a "like" operator:
Like [WhatToSearch]
Then you can enter wildcards for the parameter.

 

[Jamie Collins]

Like "*" & [Your Parameter] & "*"

Better to be ANSI mode neutral:

ALike '%' & [Your Parameter] & '%'

PS I assume the OP erroneously uses the word 'word' in the title of
their post because the above makes no attempt to distinguish words.

Jamie.

--