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