Query for looking for a word

[Shazz]

Hi can anyone tell me how I do a query that will bring up a box that I type a word into and it will then find any records with that word, I know how to do a Start anbd End Date one but not sure about this.

Can anyone help?

Shazz

 

[David Eagar]

Like "*word*"

 

[Shazz]

Thanks for that, but that is not what I want.

What I am after is when you click on the query a box pops up and you type the work you want to look for in the Box and press search.

Thanks

Shazz

 

[Scooterbug]

for the criteria in the field you want to search:

like "*" & [Enter your Search Word] & "*"