Query for fields containing a value

[Weresmytriple]

Hi

I'm currently trying to make a simple phone book database that use queries to search through the records. I need to set the search parameters to pick up all records containing a value rather that just search for that specific value.

For instance if I type in "mic" and search I want all records containing mic to appear in results like mick and Michael.

Is there any way this can be done?

So far I have only tried the [please enter first name] method and this has been in successful.

Thanks for any help

Michael

 

[pbaldy]

Try

Like "*" & [please enter first name] & "*"

 

[Weresmytriple]

Yeah that worked great thanks

 

[pbaldy]

Happy to help!