This is my first post so please help me out !! ;)
I am writting an application in VB.NET to print orders. The orders are shown on screen in a listview and the user can select individual orders/range of orders to print.
This Access query looks like:
PARAMETERS OrderIds Text ( 255 ); SELECT orders.*, orderdetails.* FROM orders, orderdetails WHERE orders.orderid=orderdetails.orderid And orders.orderid IN (OrderIds);
How do I from vb.net pass the OrderIds parameter into this query with mulitple orderids?
e.g. passing "123-456" works
passing " '123-456', '123-789' " doesn't.