Search Results Not Complete 1

[beeorlando]

I have a query in which you enter a key word to search a description field and it is supposed to return all instances of that word. My criteria is:

Like[Enter Key Word]& "*"

If I enter the word Contract

...my results include records with these descriptions:

Contractor Record
Contract Administration
Contract 655

...but not these:

1. Proposal, 2. Contract, 3. Correspondence
2. Consultant Contract/Supplemental Agreements

I know I need to add something to the search criteria but I haven't a clue what to add.

Any help or suggestions would be much appreciated!

Thanks.

 

[THoey]

If you want it to pick up where "Contract" is in the middle, you have to add another "*" to the front...

Like "*" & [Enter Key Word] & "*"

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[beeorlando]

Thanks it worked like a charm!