The NOT keyword may not be used in a column cell.
When entering a NOT EXIST subquery into the Column cell, enter just the EXIST clause. Then go to the Criteria cell and enter False for it.
Expressions | Subquery Fundamentals |
Filtering Rows with WHERE and HAVING | Using the Select List |
Query Fundamentals |