Hi Folks,

I need to find out if its possible to Pivot the results from a multiple table view?

we have a view that nornal returns


Col1, Col2, ..... Col10
row1
row2

But for a report they want a view to return

Row1, Row2....
Col1
Col2
...
Col10

And if one more person tells me it can be done in access....