Re: How do I find the sum of all orders per customer ID in form?

From: Rob Oldfield (blah_at_blah.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 21:46:29 -0000

You can get the total amount by just using a group query... group by the pk
of the customer and count (or sum) field(s) from the orders table.

"melissazumsteg" <melissazumsteg@discussions.microsoft.com> wrote in message
news:882C8ED0-0C53-42A0-A67E-F51AE1FE71B7@microsoft.com...
> I want to find the total amount of items purchased by each customer in an
> order form including the order being entered.

Relevant Pages

  • Re: Trouble with sendkeys - Alternative?
    ... One customer can be involved in many sales (but not ... You can then create a query based on your three tables. ... If you want to include the sum of the "Value" columns in a crosstab query, ... Graham Mandeno ...
    (microsoft.public.access.formscoding)
  • Re: year to date month to date
    ... Create a query that totals by Customer. ... Sum= Year)) * [SalesAmt]) ... > I made a query to sort by customer, sum sales,if date paid is ...
    (microsoft.public.access.queries)
  • Re: ordering by overall sales
    ... Any fields from the Customer table, you can use Group By: since these fields are the same for any customer, it won't mess things up. ... I tried that but because I have other columns in my query (ie. Ship_date, ... > To be able to order the report by the sum of sales, ... In the Total row under the CustomerID field, ...
    (microsoft.public.access.reports)
  • Re: Query
    ... how to I query the total amount of Sales inclusive of all Customers? ... First off you use LESS THAN and second you are not summing the sales per ... What if the customer had more than one sales invoice. ...
    (microsoft.public.access.forms)
  • Filter/where statement
    ... I have a large cube with 55 mill rows. ... I have a sum measure named. ... I also have a distinct count customer measure, ... I want to use MDX for this query ...
    (microsoft.public.sqlserver.olap)