Keyword Search Query

[kathie1101]

Hi

I hope someone can help me. I am using Access 2003 to create a database to keep a track of projects in my craft magazines.

I have a table that gives the magazine name, issue no, project name, page no and keywords. When I enter my data I will use various keywords to describe the project. For example, for a football card for a teenage boy I would use keywords such as football, boy and teenager.

What I need to be able to do is have a query based on this table that if I search for "football" it will pull up all records where I have used football as one of the keywords.

In my current query I can do this providing "football" is the only keyword I have used, but if I have used more than 1 keyword in my table then my query will not show any results.

Is there any way I can do this?

Hope you can understand what I am asking, and if someone can help, I would appreciate simple instructions as I am not very experienced with access

Thanks

Kathie

 

[neileg]

Try using
Like *football*
as your criterion in the query.

 

[kathie1101]

Thank you very much Neil for your help, and the very speedy response.

That is exactly what I needed

Cheers

Kathie