Using an array in where clause

[The_Doc_Man]

Really, I'm with Doc - better to use a little VBA to construct a proper IN clause which will have the benefit of utilising any indexes present on the searched field.

That was my first suggestion but the OP declined. I've got nothing simpler than this except building the query dynamically and then using a .Execute to trigger it. Except that it is a SELECT so even that isn't really going to work.