How do I create a query to sum up the business unit total by columns with heading (1.01, 1.02 and 1.03) as one column total and then with a total column for the whole comany (from 1.01 to 1.07).?
Acct No Acct Name 1_01 1_02 1_03 1_04 1_05 1_07
1000-000 PETTY CASH 4987.9 4700
1060-002 CASH - SUNTRUST 9137399.76 -5188420.15 -202340.57 1990119.41 -13447.08
1060-500 CASH - WACHOVIA OPERATING 181178.83
1150-000 A/R RESERVE 343238.5 -1908101.4
1200-248 DEFERRED REV SHORT TERM -326869.95

Thank you!