Calculations

S

Steve Moss

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
 
R

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.
 
A

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;
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top