IN and NOT IN

To filter one column in the table for data that matches any of several values that you specify, use IN.  To search for data that does not match any of the listed values, use NOT IN.

The same effect can be achieved by using OR in conjunction with = and <>, but it is often much simpler to use IN and NOT IN when searching for two or more values.

In the following example, only data where the Country is set to Belgium, Canada, France or Switzerland will pass the filter and be acted upon by the query.

<< Back to Adding criteria for the column