Problem usin "NOT IN" syntax

[victor64]

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

[jggtz]

Try :

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

[victor64]

It worked

Thank You.