Thanks for the reply mehere.
I tried that aswell, but get the same (wrong) result. I also tried adding the values as a parameter with the same result.
It only seems to accept it, if it's physically in the SQL statement. Something like:-
Code:
strsql = "select value1,value2,value3 FROM tbl1,tbl2 WHERE tbl1.value4='a value' AND tb1.value5 IN(" & my_variable &")"
This returns the correct results for me. I guess it has something to do with the way it's interpreting the values before it puts them in the query.
It does actually give a result, which is the strange thing, but only based on the first value in the array.
Ah well, guess I'll have to stick with the syntax above.
It's not a major issue because the values I'm inserting aren't selected by the user or anything so it should minimise any problems.