query and Calculate field

  • Thread starter Thread starter Dogface
  • Start date Start date
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
 
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.
 
Back
Top