Keyword search in Access

[Kerry]

I am wondering which would be the best way to create a keyword search in
access.
I have two ideas. One to create a separate table which would be a subform
within the people form with various fields ie keyword, keyword1,
keyword2,keyword3 etc, whereby the user would enter keywords about people
ie(what type of work they are looking for for instance forklift, maintenance,
fitter, electrical etc). OR within the people table add other field called
keyword, whereby the user could enter mutiple words within the text box. In
these cases which one would be better for the user to search for
keywords.???. AND how would I go about searching for MORE than just one
keyword... ie whereby the user would search for people of their chose ie
with Maintenance and Forklift. I already have a search set up for [Enter
Town] Whereby the user can enter a town and access will search the people
table and retrieve any person within the chosen town, however I am unsure how
to create a multiple user selection search that would bring up people with
EITHER Maintenance AND OR Fitter etc.

Any help would be great thanks!

 

[[MVP] S.Clark]

The LIKE operator can be used to find occurances of values within a string.

[fieldname] = "abc run dog hop"

Select * from tablename where [fieldname] LIKE "*dog*"

would return the record.