Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with searches

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Hello all,

I seem to be having a problem with my search field on the database that I have compiled.

For example, if I am searching for an entry with the word 'sling' in it, I get a search result if the work sling is the very first word in the entry, but not if it is halfway through or at any other point in the entry, only if it is the very first word.

What have I done wrong here.

Thanks in advance.

Mark.
 
What search method are you using? CTRL-F? Or are you working out of a query?

If you're using CTRL-F, change the "Match" box to "Any part of field"

If your using a query, change your criteria to:

Like "*searchtext*"

Later
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top