Originally Posted by dazlerd

Hi everyone

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:

Help with Code Tags

(Toggle Plain Text)

PARAMETERS OrderIds Text ( 255 );
SELECT orders.*, orderdetails.*
FROM orders, orderdetails
WHERE orders.orderid=orderdetails.orderid And orders.orderid IN (OrderIds);

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.

Thanks

Darren