Excluding Records

[zenzabar]

Using Crystal XI

I need to exclude any instance of records with TAB; thought a simple IF statement would work, but did not.

My data to exclude looks like this:

Zocor (25mg) TAB
Synthroid (.01mg) TAB

 

[Turkbear]

Hi,
In your record selection formula try this:

NOT ({Table.Field} like *TAB*)




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

 

[lbass]

Just a tweak:

NOT ({Table.Field} like "*TAB*")

If "TAB" could be in other cases, use:

not(ucase({table.field}) like "*TAB*")

-LB