I have a query in my access database that contains the code.
WHERE ID in ( [ idlist ] )
When I run this in access and enter one number , e g 5 , it works fine. When I type in 5,6 I get nothing.
I want to put this in a program and pass a parameter with one to a lot of numbers in it. So
1. How do I test using access. ( what should I type into the parameter box that pops up?
2. Will this work in my program?