Searching for a specifice key word in a mem field

[midgette]

Hi:

We are trying to create a report on a search for records that have a particular key word in the call description field which is memo text.

We tried creating a formula, but we got an error that says you cannot place a memo text in a formuala.

Can any one help?

Thanks

 

[synapsevampire]

Sure, if you want specific help, please flesh out your environment:

CR Version
Database type and version

The simplest method would be to create a SQL Expression that checks for the keyword and returns a value if the key word exists.

That way you can easily identify or filter rows accordingly.

-k