Subtotal and total

  • Thread starter Thread starter Beginner
  • Start date Start date
B

Beginner

I have a set of records for different customers A,B,C etc
I would like to subtotal the Cost field, total amount
field for each customer and then find total of all for
cost and total amount fields.
Is this possible using queries ?

Thanks in advance for any help

Beginner
 
The answer is most likely "Yes!". View the Northwind example database, as
it is an example of an Order Entry application.

Subtotals and grandtotals are best handled together in a report, but can be
handled seperately in seperate queries.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top