Searching for anything in a string. (1 Viewer)

[camaroltd82]

I have a store room part inventory database I just implemented. My users have requested a search query that will search for anything in a string of words (Their part descriptions) I use the following criteria in all my other queries, but this only works if they type the first few letters of the first part of the description.

LIKE [Enter Description Keyword] & "*"

All I need to know is how do I search throughout a description, for ANY key words. Thanks!

 

[antomack]

Assuming you mean that if they type the keywords 'step' it would return items which contain the string 'step' at any stage in the field then use the following

LIKE "*" & [Enter Description Keyword] & "*"

Using 'step' it would thus return items such as
stepladder
4 rung steps