I'd like to be able to pass multiple criteria into a single parameter in a vba code which calls a sql procedure.
In creating the command to call the procedure I've used is:
cmd1.Parameters("@clientcode") = "AB3,BM1"
which returns no result.
The section of the sql code which relates to the parameter is:
where T01.ClientCode in (@clientcode)