Subtotal and total

[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

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-