Hi Gail, Jeff,

Gail: Thanks for the tip. Pivoting the data certainly sounds like what I am after. I'll take a look at that behavior.

Jeff: The result set I would like is as follows:

Project PhaseProject Status

---------------------------

BuildCancelled

ClosureComplete

ImplementationIn Progress

InitiateLogged

PlanOn Hold

Transition

I appreciate your feedback.

Cheers,

Wayne