Rex
asked on
In Access SQL, How Can I make A Query that Selects Records that Contain All or Part of a String
I need a Query with a WHERE Clause that picks up on strings, or parts of a string, in a field that may contain multiple text strings besides the ones I am trying to selectively choose.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks!. I just needed the simpler version to make it work.
you can try this
Where [field] like "*" & yourstring & "*"
in QBE design
Field [FieldName]
Table
Criteria like "*" & yrString & "*"
or
Field [FieldName]
Table
Criteria like "*" & [Enter String] & "*"