Microsoft Access Database Development With VBA

SQL Keywords: IN

   

Description

The IN keyword is used to select one from a group of values. The formula to follow is:

IN(Expression1, Expression2, Expression_n)

Each Expression factor can be one of the values of a column. This is equivalent to Expression1 OR Expression2 OR Expression3, etc.

Here is an example that shows the list of movies directed by either Oliver Stone or Ron Howard:

SELECT Videos.Title, Videos.Director, Videos.CopyrightYear, Videos.Rating
FROM Videos
WHERE (Videos.Director) IN ("Oliver Stone","Ron Howard");
     
 

Home Copyright © 2012 FunctionX, Inc. Home