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!
Full Version: how to perform total on query
QUOTE (DEADEND @ Apr 21 2010, 03:11 PM) 
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!
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!
Welcome to UtterAccess.
I normally handle the totaling and summing in the report
Is this a cross tab query?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.