SQL error - Wrong types

[Lord Zarm]

The error I am getting is
"Arguments are of the wrong type, are out of acceptable range or and in conflict of each other. 3001"


I am trying to filter out a record set so that it only shows codes that are in my list.

strDedList = "'D06','D03'"

AND voldedcode1 IN(" & strDedList & ") "

I know the above works with integers... I guess it doesnt work with strings. Is there some other method I need for strings?

[Twodogs]

Try

strDedList = "''D06'',''D03''"

AND voldedcode1 IN (strDedList)

That is DoubleQuoteSingleQuoteSingleQuoteD06SingleQuoteSingleQuoteComma etc