• 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.