Keyword search

[Guest]

I am building a database that includes a keyword field that can contain more than one word. I need to create a query that will search all the words in the field and return the records that include the keyword entered by the user. Any ideas for a query?

 

[[MVP] S.Clark]

Select * from Table WHERE fieldname LIKE "*keyword*"

To perform this dynamically will require VBA code.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I am building a database that includes a keyword field that can contain

more than one word. I need to create a query that will search all the words
in the field and return the records that include the keyword entered by the
user. Any ideas for a query?