Search on text fields - Wildcard?

[Harley Guy]

Good morning all...I would like to have a query where someone could enter any search string on a task. IE: If someone wanted to know what employees could do any task involving windows, user could enter in the word "window" and it would return any tasks contianing the word "window". User could use the same query and enter in the word "insulation" and all tasks would come up containing the word insulation.

I'm fairly certain Access has the ability to do this but I don't know the correct parameters.

Thanks in advance!

[JoeM]

If you enter the following expression in the Criteria row of the Field you want to search the item for, it will prompt you for an entry whenever you run the query, where you can enter whatever you want to look for, and it will return all records meeting that criteria:
Like "*" & [enter word to search for] & "*"

[Harley Guy]

I knew it was something easy...worked like a charm Joe...thank you very much!

[JoeM]

Your welcome!