Hi there,
Try looking up the PIVOT funtion in BOL.
If you still having problems let us know and we help you with your code.
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]