Passing parameters to a In([MyParameter]) function

Rocket · March 17th, 2005, 10:21 AM

Hi, I'm new to the forum so hope this is in the right place.

I'm trying to pass some parameters to a two part query in Access.

The problem is i need to use the in() function in the query and i can't get the syntax right.

Code:

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open strConn
       set rsP=createobject("adodb.recordset")
    conn.QRY_COUNT_PATIENTS_AUDITED StrCBIDs,vSD,vED,rsP

StrCBIDs would look something like 19,20 which would normally be fine if i stuck it straight into the Access query but it's not working correctly - to be exact it's turning up an empty recordset -.

If i replace StrCBIDs with an integer i.e 19 then it works fine so it's got to be a problem with 19,20...,etc but i don't know what.

Any ideas would be gratefully received.

Thanks

R.