Access MS Access multi column table transpose

[dnorberg]

I need to transpose a table with many columns in Access 2003. Any ideas how this can be done with a module script or union query?
Many thanks
Dan

 

[knight00779]

Hi,
if my understanding is in track with yours on transposing a table columns is displaying the table columns as rows, and data rows as columns.

an option which i could think of suggesting is of using Excel.

You got to fetch the data using Excel MS Query Editor, then use Transpose function, Returns a vertical range of cells as a horizontal range, or vice versa

hope this is gives you respite.

Regards