Rotate table help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

I have a table in the structure

name Nov Dec Jan Feb Mar ...
bob 1 6 8 7 9
alice 3 2 4 7 9

But i need to produce a month by month graph where bob and alice are the
datasets (rows), and the months are the points in the graph. I think i need
to create a query that rotates the table to the form:

Month Bob Alice
nov 1 3
dec 6 2
jan 8 4
...

Can someone please help with this? I cant change the table structure but i
can create additional tables.

Thanks.
 
Thanks for the reply. I know its not normalized, it was created to facilite
a report needed and now they require another report.

Thanks for the help, your suggestion works.
 
Back
Top