what you're looking for is called a crosstab query or crosstab display see this article for details -- What is a cross tab query and how do you create one using a relational database? http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25 ;o) rudy http://rudy.ca/