Help creating a search query

  • Thread starter Thread starter Mike Fellows
  • Start date Start date
M

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