Problem usin "NOT IN" syntax

Hello,

What is the proper syntax for searching using the NOT IN command, the IN sybtax works, but the NOT IN is not the proper syntax.


IN Syntax:

myaop29report.RecordSelectionFormula = "{AOP29.field2}in [ " & xyz & "]"

NOT IN Syntax: Error Message (boolean or string expected)

myaop29report.RecordSelectionFormula = "{AOP29.field2} not in [ " & xyz & "]"

Thanks,

Victor

Try :

Code:

---

myaop29report.RecordSelectionFormula = "NOT ({AOP29.field2} IN [ " & xyz & "] )"

---

It worked

Thank You.