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

M

melissazumsteg

I want to find the total amount of items purchased by each customer in an
order form including the order being entered.
 
R

Rob Oldfield

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.
 
R

Rob Oldfield

...and I forgot. To make sure the current order is included just save the
record first...

docmd.runcommand accmdselectrecord
 
Top