.. Hi peeps. I have search for guidance but google isnt doing its job like it used to and would like to reach out to yall for help.
My problem is below and i am doing this in access 2007.
I have a table Hobbies:
Hobbies
|names||city||DOB||keywords||
Records for example, would be like:
|James Ross||London||12/12/85||cricket, snooker, electornics, building||
|David Magambo||Manchester||01/09/87||gaming, biking, poker||
|Hans Gruber||Berlin||01/01/73||smoking, programming, gaming, tennis||
I want to be able to search the comma separated string for words. for example if i were to search for the people with the keywords "gaming" it would bring up David and Hans recrods, or if i were to search for keywords "cricket" or "tennis" it would bring up James and Hans records..
Im guessing it would be an sql query? and it might be trivial but i have no idea how to go about this and would really appreciate the help.
Thanks, Julie.
My problem is below and i am doing this in access 2007.
I have a table Hobbies:
Hobbies
|names||city||DOB||keywords||
Records for example, would be like:
|James Ross||London||12/12/85||cricket, snooker, electornics, building||
|David Magambo||Manchester||01/09/87||gaming, biking, poker||
|Hans Gruber||Berlin||01/01/73||smoking, programming, gaming, tennis||
I want to be able to search the comma separated string for words. for example if i were to search for the people with the keywords "gaming" it would bring up David and Hans recrods, or if i were to search for keywords "cricket" or "tennis" it would bring up James and Hans records..
Im guessing it would be an sql query? and it might be trivial but i have no idea how to go about this and would really appreciate the help.
Thanks, Julie.