How do I get (salt) in a query from a field containing (salt, pep.

[Guest]

After creating a query that calls out the criteria [ingredient], how do I get
all records containing salt when the field contains numerous ingredients.
Such as: salt, pepper, sugar, etc

 

[John Nurick]

Use the LIKE operator, e.g.

LIKE "*salt*"

After creating a query that calls out the criteria [ingredient], how do I get
all records containing salt when the field contains numerous ingredients.
Such as: salt, pepper, sugar, etc

 

[Brendan Reynolds]

Use the LIKE operator. For example ...

SELECT tblTest1.*
FROM tblTest1
WHERE (((tblTest1.TestText) Like "*salt*"));

See the help topic on the LIKE operator at ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322531033