Help creating a search query

[Mike Fellows]

im trying to create a free text search query within access

i have 10 fields i want the search to run in and im unsure where to start


ive tried using Like [enter search text]
and using OR between each field

i.e.

like [test]
like [test]
like [test]

this pops a box up (named test) where i can enter the text i want to search
for
but this always returns 0 records

im nut sure where im going wrong here and if im even using the Like command
correctly

any help with this would be appreciated

 

[[MVP] S. Clark]

Unfortunately, the simple parameter query method is not very useful after
more than a couple of fields, especially when an OR condition is needed.

Create a form.
Add controls for the user to select the values.
In code, create a SQL Statement that generates the desired result set to a
form or report.

--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-