I am using Access 2000. Is there any SQL statements or Access built-in functions that can switch the rows and columns of a table?<br><br>I have a table of expense data. The fields are "Travel", "Supplies", "Equipments" and etc. I input data quarterly. Therefore the primary key of this table is QuarterID, such as 2000/1, 2000/2, etc.<br>Now My boss needs an annually financial report. The format is that: 4 columns(each column for one quarter of the year), a dozon rows(each row for one expense).<br><br>All I can do now is to create a new table with fields expenseid, quarter1, quarter2, quarter3, quarter4. Then I write VB code to convert the data from my expense table to this new table.<br><br>Does someone has better idea?<br><br>Thanks in advance.<br><br>Seaport