Question with Query Criteria

[tyleri]

I have linked an Excel Spreadsheet to my Access database, and I am trying to put together a query that pulls information if the field contains one word in a series of words.

Specifically I have a field that might have "Jon Doe" or it might have "Jon Doe / Jane Smith".

In the query criteria, if I type "Jon Doe" it shows me all the fields with just Jon Doe, and none with "Jon Doe / Jane Smith".

How can I get the query to select ALL fields that contain the string of text I'm searching for?

Thanks

 

[Rick39]

Try:
Like "Jon Doe" & "*"

 

[tyleri]

excellent! now to expand upon that, I am pulling the string i'm searching for from a combo box (combo_1).

[forms]![main_form]![combo_1] is the string I usually use to pull the information from that combo box. how would i incorporate that into this issue?

i tried: like "[forms]![main_form]![combo_1]" & "*" but no luck.

 

[tyleri]

nevermind i got it

like [forms]![main_form]![combo_1] & "*"

 

[Rick39]

Try:

like [forms]![main_form]![combo_1] & "*"