and not or and not

[mwhalen]

does anyone have any tips for how to construct this and the syntax? I have:

and (not ({ATABLE.OLDS} in ["03", "06"]) or
not ({BTABLE.NEWP} in ["123456", "987654"]))

 

[DjangMan]

Describe what do you want it to do and we'll be able to help you more.

DjangMan

 

[Ngolem]

if this is in a record select formula I think this will be VERY slow....using NOT in this fashion

 

[kenhamady]

It would help if you explained what you want in English. Since you are unsure of the syntax, we don't know for sure how to read what you have written.

You have 2 booleans. Do you want records that meet either or both negative booleans? Your OR seems to mean Either.

Are there other conditions (since it starts with AND)? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[FoxG]

Hi,

Just out of interest:

(not x or not y) is the same as not(x and y) !!

Geoff