Home

Microsoft Access SQL Operators: IN
 

Introduction

You can use the IN operator to select values from specific categories. After the SELECT expression of the statement, the formula to use IN is:

IN(Value1, Value2, Value_n)

The IN operator is followed by parentheses. Inside the parentheses, type each of the desired values from the column on which to apply the filter, separated by commas.
 

Using IN

To create an IN operation:

  • Use Filter By Form on a table, a query, or a form. After opening the list, click the combo box under a column and type the IN expression
  • Get the grid, use the Advanced Filter/Sort option from the Advanced button of the Ribbon. Select the column you want to use. In the Criteria box that corresponds to that column, enter the IN expression. Here is an example:
     

If you want to save the list, start a query and display it in Design View. Select the column(s) you want to use. In the Criteria box that corresponds to that column, enter the IN expression.


 
IN

 

 
Home Copyright © 2008 FunctionX, Inc.