Thanks for the attempt at this.
I've been able to incorporate those additional requirements into the query.
For REQ #1: I simply added a 2nd table into the report and that took care of this requirement.
For REQ #2: I ended up changing the data type when creating my temp table. The problem was occurring due to the data type being varchar so I changed it to float and then I was able to summarize the data in the columns.
Not sure if I had mentioned what I was using this SQL query for.
I will be using to gather data into a temp table and displaying the results in a report using Crystal Reports XI.
Thanks for all of your help.