query and Calculate field

D

Dogface

I just created a query that determines the dollar amount of merchandise
ordered by each customer on each order.

Now I need to just show the total amount each customer has purchased (i.e.
the sum of all orders per customer).

I'm really brain f@rting on this. I am an obvious Access novice.

Thanks

GW
 
J

John Vinson

I just created a query that determines the dollar amount of merchandise
ordered by each customer on each order.

Now I need to just show the total amount each customer has purchased (i.e.
the sum of all orders per customer).

I'm really brain f@rting on this. I am an obvious Access novice.

Thanks

GW
Click to expand...

If you want a query to show *just* the total per customer, change this
Query to a Totals query by clicking the Greek Sigma icon (looks like a
sideways W). Group By the customer ID and Sum the dollar amount.

If you want to see both the details of the individual items, and also
the sum per customer, you can't do it (at all easily) in a single
Query. Instead, use a Form; use the Form's Sorting and Grouping dialog
to group by customer, and put the totals in the section Footer.
 
Top