Hi,
My question is about a complicated Access query.
The knowledge base table has four different keyword fields and other fields.
When entering a new knowledge item, I usually enter 2-4 keywords, one keyword in each keyword field.
If I do a query with four keywords, the structure should be:
Keyword1 AND/OR Keyword2 AND/OR Keyword3 AND/OR Keyword4
The combination of four keywords and AND/OR choices produces a rather complicated query.
The order of the keywords I type could be different compared with the order of the keyword fields.
When I do a query, my first keyword could match e.g. in the field "keyword2" and my second keyword
could match e.g. in the field "keyword1".
How could this kind of query be designed?
Thank you for the answer!
My question is about a complicated Access query.
The knowledge base table has four different keyword fields and other fields.
When entering a new knowledge item, I usually enter 2-4 keywords, one keyword in each keyword field.
If I do a query with four keywords, the structure should be:
Keyword1 AND/OR Keyword2 AND/OR Keyword3 AND/OR Keyword4
The combination of four keywords and AND/OR choices produces a rather complicated query.
The order of the keywords I type could be different compared with the order of the keyword fields.
When I do a query, my first keyword could match e.g. in the field "keyword2" and my second keyword
could match e.g. in the field "keyword1".
How could this kind of query be designed?
Thank you for the answer!