 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / January 2006How do I transpose a table so that rows become columns?
What query do I use to convert rows to columns (Table 1 to Table 2)? Table 1: PackageID Status City Invoiced P10 S10 C10 100 P20 S20 C20 200 P30 S30 C30 300 P40 S40 C40 400 Table 2 PackageID P10 P20 P30 P40 Status S10 S20 S30 S30 City C10 C20 C30 C30 Invoiced 100 200 300 400 If you only want the appearance of this data, you can use a multicolumn report. Would you really expect to see PackageID as a Value in your new table? The quick and easy method is to use Excel to Transpose the values.  SignatureDuane Hookom MS Access MVP -- > What query do I use to convert rows to columns (Table 1 to Table 2)? > [quoted text clipped - 12 lines] > City C10 C20 C30 C30 > Invoiced 100 200 300 400 I need to produce a multicolumn report. Each row in the source table becomes a column in the report. Package ID values become the column headers for the report. Any ideas? > If you only want the appearance of this data, you can use a multicolumn > report. [quoted text clipped - 17 lines] > > City C10 C20 C30 C30 > > Invoiced 100 200 300 400 Consider this KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;210044&Product=acc ACC2000: How to Print Labels on the Left Margin of a Report. SignatureDuane Hookom MS Access MVP -- >I need to produce a multicolumn report. Each row in the source table >becomes [quoted text clipped - 25 lines] >> > City C10 C20 C30 C30 >> > Invoiced 100 200 300 400 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.