Creating Crystal report using MS Access query

•

What is DaniWeb IT Discussion Community?

You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 456,478 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,773 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our VB.NET advertiser: Programming Forums

Thread Tools Display Modes

Views: 5943 | Replies: 2

Previous Post in Thread

Next Post in Thread

•

Join Date: Feb 2007

Posts: 2

Reputation: dazlerd is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

dazlerd

Offline

Newbie Poster

Passing multiple Ids into one MS Access query parameter

Aug 30th, 2007

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);

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

Last edited by dazlerd : Aug 30th, 2007 at 9:48 am.