Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 26th, 2008, 01:01 AM
Authorized User
 
Join Date: Oct 2006
Location: Kolkata, West Bengal, India.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transpose Rows/Pivot Table

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.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose Table - Editing the MS KB code gwolfe Access 2 September 14th, 2007 02:48 AM
Pivot Table vbsolo Excel VBA 3 November 23rd, 2005 01:28 AM
Transpose Rows JpJoe Access 10 March 17th, 2005 08:15 AM
Pivot Table mikeparams SQL Server 2000 1 February 9th, 2005 10:10 AM
Pivot Table ramdasu Excel VBA 0 October 23rd, 2003 03:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.