Help with Range formula

[smiles44]

My formula below is giving an error saying 'The keyword "Then" is missing" and it highlights 'NOT'.

If {table1.TASKS} = 0 OR {table1.INTERVAL_LENGTH} NOT IN ["AA", "BB", "CC", "DD"] THEN "ERROR/EXCEPTION"

I would appreciate any help.

Thanks,
PS

 

[Turkbear]

Hi,
Use this:

If ( {table1.TASKS} = 0 OR NOT ( {table1.INTERVAL_LENGTH} IN ["AA", "BB", "CC", "DD"]) ) 
THEN "ERROR/EXCEPTION"

In Crystal the Not preceeds the condition to be tested.




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

 

[smiles44]

Thanks a lot! It works perfectly.