@Tyson - Interesting solution to the problem. I don't have nearly enough PIVOT experience I should have... it's not something I think of out of the box. Very cool though.

@jp261... - sigh... why do people wait until the discussion has started to mention things like the type of database? I mean, you wouldn't take your Honda to a BMW shop, as for a tune up and then as they are pulling it into the garage "Oh, by the way, it's a Honda..." No... that's part of the initial discussion.

In this case I don't know that Access supports the CASE statement, but it should support the PIVOT... so that's going to be your best bet.

-tg