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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

expression in the criteria field

Status
Not open for further replies.

zon123

IS-IT--Management
Oct 11, 2005
49
US
I Have some memo fields in my database. I would like to have a query with a criteria search of a word or two in the memo field. Example: if the data in the filed is "not a recognized user" I would like to create a query and filter the criteria to be the word 'user' and OR the word 'recognized'. What expression do I type in the criteria field???
 
Using the example you give:

[tt]Like *User* Or Like *Recognised*[/tt]

But I suspect that this is not quite what you want?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top