Query Tutorials Index:
Not Operator Microsoft Access
The Not command is one of the most commonly used functions in SQL queries.
Are you just starting out on your quest for a small business database? Need some advice or someone to bounce ideas off of? We are happy to chat with you to discuss options to your situation.
Are you looking for an MS Access template database? We have many for sale in our Access Template and Examples Software section.
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