Grouping and Summing Up To 30 Columns

Question

I have a cross tab query displaying the final results to be presented in a Report format.

I need about 30 columns to be grouped and summed together as one master column.

Having issues with Microsoft 2010 and also with the tables and field names.

Answer 1

Something like this should do it:

select (sum(t1.col1) + sum(t1.col2) + sum(t2.col3) + ...) as master
from yourTable1 t1, yourTable2 t2, ...
where ...