Query Help Request

[jcrouse1]

I have an Access 2003 DB. It keeps track of product orders. I am
attempting to sum the order total for EACH customer. I can get it to
sum the order and add shipping but it lists each order number and then
the total. The problem is that customers show up multiple times if
they have more than one order. I want to have one GRAND TOTAL of all
orders for each customer.

Any ideas,
John

 

[Jeff Boyce]

John

To use ... how? If you want to create a printed report, use your query to
feed a report and use the "Hide duplicates" property to hide the multiple
Customer value.

If you want a query to return total by Customer, use a Totals query, GroupBy
Customer, and Sum the Amount.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[jcrouse1]

No reporting is required. I just need the query for now. It's for a
school project. I will look at the Totals query, per customer, and try
to figure out how to use totals from multiple orders.

John