How can I filter the recordset using IN Clause?

[tonioJ]

I want to filter my recordset using IN clause is it possible? The filter should be like the SQL statement below.


Select * from employees where emp_no in (1,2,3,4,5)

 

[Ruffnekk]

The SQL statement you provided seems to be correct:

SELECT * FROM [employees] WHERE [emp_no] IN (1,2,3,4,5);

So yes, it's possible

Regards, Ruffnekk
---
Is it my imagination or do buffalo wings taste just like chicken?

 

[tonioJ]

Thanks for your reply. so how will i do it in ADO using filter?

just like.

rs.filter = "emp_no IN (1,2,4,6)

i'm getting an error with this statement in VB.

 

[JerryKlmns]

rs.filter = "emp_no =1 Or emp_no = 2 Or emp_no = 4 Or emp_no = 6"