How to change Columns to rows at access 2007

[Stefent Tan]

Please help me to do this,
I have a data table Name : Qry_MH_Tbl_Resu lt 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

[Stewart Ross]

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

[Rabbit]

Unpivot and normalize the data by unioning and then repivot.