UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> how to perform total on query, Office 2003    
 
   
DEADEND
post Apr 21 2010, 03:11 PM
Post #1

New Member
Posts: 1
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!
Go to the top of the page
 
+
HiTechCoach
post Apr 21 2010, 11:15 PM
Post #2

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
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!


(IMG:style_emoticons/default/welcome2UA.gif)

Welcome to UtterAccess.

I normally handle the totaling and summing in the report


Is this a cross tab query?
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 09:59 PM