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

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
http://mvp.support.microsoft.com/

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

<jcrouse1@hotmail.com> wrote in message
news:1192018645.011688.293210@d55g2000hsg.googlegroups.com...
> 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
>

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