Using Subquery for Criteria

[Jim Pockmire]

Is it possible to use a subquery to pass multiple values to a criteria
statement in another query?

 

[John Spencer]

Possibly. An example.

SELECT *
FROM TableA
WHERE TableA.CustomerName IN
(SELECT FullName
FROM TableB
WHERE FullName Like 'Joh*'
GROUP BY FullName
HAVING Count(FullName) > 1)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..