Swath, I don't have access to a server right now, but if you search for PIVOT there are countless examples here, and also on google.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.