Hello Frnds,

                    I am facing a very critical problem in my application.My application has C# as front end and MS Access as backend. I am having two table named as "tblItem" and "tblStock" in my database.

Now "tblItem" table contains follwing data:

itemName
========
Coca Cola
Pepsi
Thums Up
Mirinda
Sprite

And "tblStock" table contains following data:

itemName Quantity Date Total Price
======= ======= ======= ==========
Pepsi 2 20/04/08 30.00
Coca Cola 10 20/04/08 150.00
Thums Up 19 01/04/08 190.00
Coca Cola 2 01/04/08 30.00
Sprite 30 01/04/08 90.50

Output (where all ItemName of "tblItem" should be column name) will be like this:

Date Coca Cola Pepsi Thums Up Mirinda Sprite Total Price
==== ======== ===== ======== ======= ===== =========
01/04/08 2 0 19 0 30 310.50
20/04/08 10 2 0 0 0 108.00

Please please help me.