Query Criteria - LIKE

[cbearden]

I'm trying to set up my query where I can enter a part of a name and it searches by that. Here's what I put for criteria:

Like "[Enter Name]*"

So if I entered Bob, then all fields starting w/ BOb would come up.

Bob Jones
Bob Smith
Bob Miller

Thanks

 

[mp9]

Like "[Enter Name]" & "*

 

[Lilliabeth]

Like[Enter Name]&"*"

(I don't think it will like the quotes around the prompt.)

 

[cbearden]

I will try it. Thanks!