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

Like "*word*"

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

for the criteria in the field you want to search:

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