You are the man Paul! That seemed to get me over that hurdle. I am now getting this error on all of my aliases:

The column prefix 'rec' does not match...

Thanks for the info Paul. I am new to T-SQL and it has been suggested to me in a different forum that I keep the data from the presentation separate....