use Access database Transform statement to create crosstab query

What is a CrossTab Query?
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25


Access SQL TRANSFORM Statement
http://ewbi.blogs.com/develops/2005/01/access_sql_tran.html