Query Tutorials Index:
Not Operator Microsoft Access
The Not command is one of the most commonly used functions in SQL queries.
We have dozens of downloadable Access small business databases for you to learn and examine.
With our new partnership with Jay McCormick we have extensive programming support in SQL/Server database, MS Access software, Power BI applications, .Net web development, PHP, Excel & Outlook customization.
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:
Here is the same query viewed in SQL View showing the Microsoft Access Not In Query:
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.
Copyright 2000-2017 Blue Claw Database Design
Development in Microsoft Access, Microsoft SQL/Server and Azure
See our SQL/Server Development and Access Migration Tutorials