@Laurie, Mark, GSquared. I am humbled.

I was starting to lean towards Cross Join; however, I'd never had an opportunity to use it before. Seems like it behaves a bit like a pivot table??

GSQuared, dito, never used Coalesce before. Guess I need to hit the books and learn these two techniques. The results are exactly what I needed.

I will try all three results for performance against a test version with about 100k records....

Thanks all.. .I really appreciate your help.

Sincerely.

Crusty