Someone sent us a question the other day about one of my favorite dark corners in Access and we thought it might be interesting to dive into this area a little. Microsoft Access SQL supports two uses of the IN keyword.
Go here to see the original:
Accessing external data using the IN clause