query on any part of description feild

[rainbows]

hi,


I would like to query a description field for any part of any word



for example in my description field I could have , " stator laminations"


or" laminations for exciter "


I want to query on the word " LAM " etc


thanks steve

 

[Eljefegeneo]

Is this what you want?

https://www.techonthenet.com/access/queries/like.php

 

[rainbows]

hi ,

I do not know what the word will be in advance it could be anything the user wants to query on

I would like the criteria to be any user input

ie. it can search on "stator" "rotor" but if I want any input the word " lams" instead of "laminations"

the reason I want that type of search to query on is because different users use different words for the same part

thanks
steve

 

[Tieval]

Put in a query that the form is based on that the desciption is:
Like "*" & [Forms]![SearchForm]![SearchTextbox] & "*"

 

[Eljefegeneo]

Like "*" & [Enter Word] & "*"