Selecting multiple values from a field

[campsb]

How do I select multilple values from a field that holds multiple values? For example I have a field that has A,B,C,D and what I want is all records that have B, C or D.

 

[synapsevampire]

if not("A" in {MyTable.MyField}) then
"B, C, D" else
"A"

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

Or

If Not('A' in {MyTable.MyField})
Then {MyField}