Entering a name in query

[jon01]

I have the table for tennis players and I created a query to where you can enter the name. The problem is that when I put [Enter name] in the query criteria, I have to type the full name to get results.



For example: "Paul" doesn't give any results, but "Paul Smith" does.

How can I modify the query so, that when I type "Paul", I get "Paul Smith", "Paul Johnson" and all other Pauls into the results?

[cap.zadi]

Hey,

hope this will help you.

http://www.fontstuff.com/access/acctut06.htm

bye

[aytee111]

Like "*" & [Enter Name] & "*"

[jon01]

Like "*" & [Enter Name] & "*"

Thanks a lot, it was exactly what I was looking for.

[jon01]

There's seem to be a problem with it now, because the Enter Parameter Value pops up twice. I don't get it, because I only have one form and no subforms. It appears to be doing it because I sorted one column after the first search.

[aytee111]

Every time the query runs the message will pop up. If you are running the query on a form then you can put a text box (combo box?) for the name on the form instead of in the query. The query can then reference the field on the form instead (criteria would be something like "Like "*" & Forms!FormName!FieldName & "*")