A
Abbey Krystowiak
In my database I have a table with information about studies that have
been done. One of the fields (columns) I have is "Keywords". However
there are multiple keywords for each of the studies. I want to be
able to search in a query by keywords after being narrowed down to the
product category of which the study was done about. Is there anyway I
can do this table to have all the keywords be in one line so I don't
have multiple lines of everything the same except for the keyword,
because if i just type "keyword1, keyword2, keyword3..." the query
doesn't work.
been done. One of the fields (columns) I have is "Keywords". However
there are multiple keywords for each of the studies. I want to be
able to search in a query by keywords after being narrowed down to the
product category of which the study was done about. Is there anyway I
can do this table to have all the keywords be in one line so I don't
have multiple lines of everything the same except for the keyword,
because if i just type "keyword1, keyword2, keyword3..." the query
doesn't work.