At the bottom of this is the text from my previous question, which I did 
resolve.  Much thanks to the individuals who responded.  But now I have a 
possibly more challanging quesion.  What if my table had another column of 
info and the new column heading neaded to be Quarters, Year1_someinfo1, 
Year2_someinfo1, ... , Year1_someinfo2, Year2_someinfo2, etc....


--------------------------------------------------------------------------

Suppose I have a table.  
                                            (Added)
YEAR      QUARTER        SOMEINFO1         SOMEINFO2
  1          1              x                  x 
  1          2              x                  x 
  1          3              x                  x 
  1          4              x                  x 

  .          .              .                  . 
  .          .              .                  . 
  .          .              .                  . 

  4          1              x                  x 
  4          2              x                  x 
  4          3              x                  x 
  4          4              x                  x 

The table has been created this way over the years and can't be changed 
itself.  But I want the years to be turned into the column headings.
I am new to the sql language, but did manage to get this to work in access.
Now I have to get it done with sql 2000.  I would appreciate any help with 
this.
Thanks
William Markham