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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to find the total amount of items purchased by each customer in an
order form including the order being entered.
 
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.
 
...and I forgot. To make sure the current order is included just save the
record first...

docmd.runcommand accmdselectrecord
 
Back
Top