Quote Originally Posted by techgnome View Post

@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
heheeh i sorry sir.. i forgot to mentioned that yesterday.. i will be careful next time.. anyway thanks for your reply,..

@nubie: Thank you sir.. your solution solves my thread..