Search for a specific word using Query 1

[l3reacher]

Hi, I have table called Tabl1. I have a field called "Notes". What I want to do is to create a query that can capture a specific word such as "for" within a sentence in the field "Notes". I want to know which sentence has that word.

I Hate Spammers and Flammers!!!

 

[psemianonymous]

The quickest way is to put this in the Criteria section of the query builder, for the Notes field:

LIKE "*" & [Enter the exact phrase you want to search for] & "*"


It's not perfect, but it's a 3-second answer (try its perfection: enter nothing at all in the search box, enter "*" in the search box, etc). If you want to do multiple-word searches (like a search engine), you're mostly out of luck. Anything more complex than a single-phrase search takes a lot more work.

 

[l3reacher]

Works Great! Thanks alot!!!!

I Hate Spammers and Flammers!!!