Subtotal in Queries

[Anthony Lisanti]

Hello All


I have a database with 3 queries for a trail balance. It breaks out
Domestic, International, and affiliates and dumps them into an excel
file. I then have to do an extra step to sub-total by Customer name
on each of the 3 tabs. Is there a way to add this into my query, so
I don't have to do an extra step. I'm new to Access, and can
basically just do basic queries.


Thanks

 

[Arvin Meyer [MVP]]

No, but you can use Automation to open a particular Excel workbook, dump the
data on a particular worksheet and use a range on that worksheet to supply
the total cells. You might find the following to be helpful:

http://www.mvps.org/access/modules/mdl0035.htm

 

[Al Campagna]

Anthony,
A more detailed description, or some example values would be
helpful...
You can do a Totals query (in query design see View/Totals)
Given this sample data...
ClientID CName Amount Area
143 Bob 5 Dom
143 Bob 7 Dom
198 Bill 12 Aff
143 Bob 9 Dom
198 Bill 10 Aff

A Totals query would yield this...
ClientID CName Amount Area
(GroupBy) (GroupBy) (Sum) (GroupBy)
143 Bob 21 Dom
198 Bill 22 Aff
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."