like function

[brino]

hi all !

i want to use the "like" function in a query but i want the user to
enter the search variable.
i have tried "like[enter name to search]" but this doesnt return any
results for some reason.
any ideas ???

thanks
brino

 

[BruceM]

Like "*" & [Enter name] & "*"

will return American Gear Company and North American Telecom if "Am" is
entered in the box. If the criteria expression is:

Like [Enter name] & "*"

it will return only American Gear Company, since that is the only one that
starts with the specified letters.

 

[Douglas J. Steele]

Where are you entering this? And do you want the search to find what the
user typed anywhere in the text, or only at the beginning of the text?

If you're typing it in the Criteria cell in the graphic query designer, try

LIKE [Enter Name To Search] & "*"

to find what they typed at the beginning of the string, or

LIKE "*" & [Enter Name To Search] & "*"

to find it anywhere in the string.