Lowell,

I removed the alias and it worked perfectly. On to the union now....

Thank you so much for looking at this!

Yes, its SQL and an error stemming from my understanding of the "Case" statement or lack thereof. Its ignoring my FROM statement because I'm using the ||','|| after the case...