Help with search in mulltiple fields 1

[biggerV]

Looking for a little assistance.

I have been away from the Crystal scene for awhile and I have been asked to assist short term for a project.I am having difficulties and I am hoping someone can point me in the correct direction. What I am trying to do is search multiple fields for the inclusion of one of multiple terms. For example I need to search for the word "cat" or "dog" in 2 different fields and display that record if that term appears in either one of these 2 ({field.a} or {field.b}) fields. Any help would be greatly appreciated.

 

[Turkbear]

A record selection formula like:

{table.a} IN ["cat","dog"]
OR
{table.b} IN ["cat","dog"]


should do it.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[biggerV]

Thank you for the quick reply!