I have the Union from hell. 9 tables to be exact!

To make the columns fit together I have used :
'ARM # '+ltrim(str(Progedd_Demos.Arm))+space(14) as label1

Would you believe that you can't goup by that succker! Any work arounds that you folks could thing of?

__Stephen