multi keyword search

[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!

 

[Golfinray]

I think Allen Browne at www.allenbrowne.com or Martin Green at
www.fontstuff.com will give you some insight into that problem.

 

[don]

I took a look, but nothing popped out relating to multiple keyword searching
across columns -

 

[John W. Vinson/MVP]

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!

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.