Reference to Form Field in Query: Searching for Like Values

[Sumnor]

Hello. I have a query that references a form field as query criteria:

[Forms]![Team]![Team]

The Team field on the form allows the user to select one (1) name. An example of some of the form field values:

Sandy
John
Jennifer

The query successfully brings back all records that meet that criteria. The problem is that some of the records contain team names like:

Sandy/John
Jennifer/Sandy

I don't want to require the user to select all possible combinations where their name is referenced. I want them to be able to select their name on the form and have the query search for all records containing that name.
In other words, if the user selects 'Sandy' on the form the query results show all records that contain 'Sandy' in the team field? The results would be like:

Sandy
Sandy/John
Jennifer/Sandy

Any help/direction is greatly appreciated.

 

[lespaul]

WHERE Team LIKE "*Sandy*"



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[Sumnor]

Thanks, Leslie - that certainly does works when entering/searching for a constant value. My question is a bit more complicated than that. I need to find a way to pass a value from a form to complete the search.

 

[Sumnor]

I figured it out - a syntax issue - and can't believe that this was so 'difficult' for me to figure out. Geesh!

Like "*" & [Forms]![Team]![Team] & "*

 

[lespaul]

glad you got it. It's the * (or % in TSQL) that makes the LIKE clause work!