By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

How to change Columns to rows at access 2007

P: 4
Please help me to do this,
I have a data table Name : Qry_MH_Tbl_Result as below

Trading date MB-01 MB-02 MB-03 MB-04 MB-05
01/02/2011 5000 5000 5000 2000 1000
02/02/2011 -1000 2000 2000 2000 2000
03/02/2011 6000 1000 1000 1000 1000

I want to make a Report that shown like as below

Trading_date 01/02/2011 02/02/2011 03/02/2011
MB-01 5000 -1000 6000
MB-02 5000 2000 1000
MB-03 5000 2000 1000
MB-04 2000 2000 1000
MB-05 1000 2000 1000

Can Some one here help me ? Thanks
Feb 12 '12 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
It is not possible to do this with the built-in functionality of Access 2007. It can be done in Excel using Transpose when pasting data, but not in Access.

-Stewart
Feb 12 '12 #2

Rabbit
Expert Mod 10K+
P: 12,366
Unpivot and normalize the data by unioning and then repivot.
Feb 12 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.