Andy, you might get some help if you posted table structure and sample data, including create and insert statements, and a sample of what you want the results to look like
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.