Not Operator Microsoft Access

The Not command is one of the most commonly used functions in SQL queries. The Not function can be used anywhere you are using a comparison operator such as = (equals), < (less than), > (greater than), Exists, and the In operator.

The example below show a query in Microsoft Access employing the SQL Not operator. There are three examples on the criteria line:

Not Null (is not null)
Not = (not equal)
Not In (Not Exist)

SQL Not

Here is the same query viewed in SQL View showing the Microsoft Access Not In Query:

SELECT performance_report.Category, performance_report.Date
FROM performance_report
WHERE (((performance_report.Category) Is Not Null) AND (Not (performance_report.Date)=#7/9/2007#) AND ((performance_report.Category) Not In (select category from google_urls)));

The SQL Not operator gives you the exact opposite set of results compared to using only the regular restriction operators (In, =, >, <. etc).

Setup your own test queries and see how easy it is to use the Not SQL operator.

Microsoft Office:
MS Access 2000 Through Access 2016 & Office 365

Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016

Not Operator/Not In/Not Equal/Is Not Null

Not Operator Microsoft Access