query help

[gripper]

I have an Access DB with a table Keyword.

I have a query set up with field "Keyword" in the first column and "ID" and the second. What I need is help with the criteria syntax.

This table has many records and I am trying to see if current strings are present in the Keyword column.

I wrote the following

Like '%vehic%' or '%motorc%' or '%boat%

The keyword column usually has 3-5 word phrases and I am seeking any record that has Vehicle
Motorcycle or
Boat
anywhere in the cell

I know the words are there but I am not getting anything back. So I obviously have the syntax wrong.

Any help would be appreciated.

 

[jackd]

It would help if you would post your query so we can see what you have tried.

You could have something along this:

SELECT * from MyTable
WHERE
(KeyWord Like "*" & "vehi" & "*" ) OR
(KeyWord Like "*" & "motorc" & "*") OR
(KeyWord Like "*" & "boat" & "*")


Good luck

 

[gripper]

Your right I would be better to post the SQL.

Here it is

SELECT Keyword.Keyword, Keyword.ID, Keyword.File_Name
FROM Keyword
WHERE (((Keyword.Keyword) Like '%vehic%' Or (Keyword.Keyword)='%motorc%' Or (Keyword.Keyword)='%boat%'));

 

[Joe4]

Jackd gave you what you need, you just need to change your WHERE clause to use the methodology he showed you how to use:

SELECT Keyword.Keyword, Keyword.ID, Keyword.File_Name
FROM Keyword
WHERE (((Keyword.Keyword) Like "*" & "vehic" & "*" Or (Keyword.Keyword) Like "*" & "motorc" & "*" Or (Keyword.Keyword) Like "*" & "boat" & "*"));

 

[gripper]

Thanks guys. That did the trick.