I want to use the IN (15,16,17) clause in Access SQL togheter with an
parameter, my query look like this, and works fine:

SELECT Svar.P?st?ende_Nr, First(P?st?enden.Nummer) AS Nummer,
First(P?st?enden.P?st?ende) AS P?st?ende, Avg(Svar.Svar) AS Svar
FROM P?st?enden INNER JOIN (Personal INNER JOIN Svar ON Personal.Personal_Nr
= Svar.Personal_Nr) ON P?st?enden.P?st?ende_Nr = Svar.P?st?ende_Nr
WHERE Personal.Item_Nr In (15,16)
GROUP BY Svar.P?st?ende_Nr
HAVING Min(Year([Personal].[Datum]))=[pn?r]) AND
Min(Year([Svar].[Datum]))=[pn?r];

I would like to have it like this: WHERE Personal.Item_Nr In ([psItems])
where then psItems="15,16,17", why dosn't this work, and how can I get it to
work?

Mikael Tilly

        I'm affraid It won't work unless you concatenate the string
        instead of passing as a parameter.
        Look, in the MSAccesxx it is not posible that way,
        so, in VB neither... 8-(
        You already have the SQL string, just concatenate you param-string
        and try.

        PD.
        The Access workaround is on Access KB
        INF: How to Create a Parameter In() Statement
        Article ID: Q100131

HTH
Raul Coba Poot