Matt

If you need a crosstab query like you do in Access, then you have to move rows into columns. If you also need ANSI 92 SQL that will run in any database, well there are several ways to do this, but the most generic and one of the most powerful ways is called the Rozenshtein Method. Stephen Forte describes his implementation in his blog at http://www.stephenforte.net/owdasblog/PermaLink.aspx?guid=2b0532fc-4318-4ac0-a405-15d6d813eeb8