Wildcard Problems. (1 Viewer)

This is making me mad now i want a query to search for what a user inputs into the query. but for example if i seach in a field wheres there is one or more words in it. eg. I want to search my table for a address (60 donnington road etc) so in the user input box i type "donnington" but i get no results even though it should find "60 Donnington Road"

code i used. [Please enter address] now where does the wild card go?!?!

hope that makes sense
thanks

I've never tried this but maybe

Like * & [Please enter address] & *

i give it a try thanks for the help

It works thanks again