multi keyword search

  • Thread starter Thread starter don
  • Start date Start date
D

don

I have a query which does a single keyword search across multiple columns.
anyonme have any code sample for being able to enter 2 or more keywords, and
query would return where Any or All of the terms were found.

Thanks!
 
I took a look, but nothing popped out relating to multiple keyword searching
across columns -
 
don said:
I have a query which does a single keyword search across multiple columns.
anyonme have any code sample for being able to enter 2 or more keywords,
and
query would return where Any or All of the terms were found.

Thanks!
Click to expand...

The need to do this strongly suggests that your table is incorrectly
designed; do you have fields Keyword1, Keyword2 and Keyword3 or the like? If
so, consider a more normalized structure with TWO tables, in a one to many
relationship. The second table would have a link to the primary key of your
table and the keyword value.

Given your current structure you can use a criterion of

IN ("normalization", "relational", "database", "table")

on each of the keyword fields; put each criterion on a different Criteria
line in the grid to use OR logic so any of the keywords will be found in any
of the fields.
 
Back
Top