Calculations

[Guest]

I have a database through which I produce Invoice Reports containing Labour
costs, and total cost of products used for each job. Each Invoice is unique
to a certain person. What I would like to do is produce a form or Report
giving me the Grand Total Labour and the Grand Total Products Used for all
Invoices relating to each person. For instance one person might have 5
Invoices relating to them, and I would like a quick reference of totals. Any
ideas how I go about it.

Steve

 

[Rick B]

You might want to take a look at the Northwinds database that ships with
Access.The form "Customer Orders" is a great example of what you are trying
to do.

 

[Arvin Meyer [MVP]]

Drop this query into the Northwind sample database to see how to set up your
own query to use as a recordsource for a report. Watch out for word
wrapping. I separated the lines to make it easier to read:

SELECT Customers.CustomerID, Customers.CompanyName,
Sum([Quantity]*[UnitPrice]) AS Total


FROM Customers INNER JOIN (Orders INNER JOIN [Order Details] ON
Orders.OrderID = [Order Details].OrderID) ON Customers.CustomerID =
Orders.CustomerID


GROUP BY Customers.CustomerID, Customers.CompanyName;

 

[Rick B]

Arvin posted another item that will help you get the totals. Sorry, I told
you how to see all the orders, but did not explain how to see total dollars.