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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create custom labels from an csv file + Need items numerically counted out 0
Mailmerge - page breaking to new customer 1
How to implement two shifts per day with multiple teams 0
Total box at bottom of form 2
Page numbering with Merged Document and IF statements 1
Copy previous record into form field 0
Access 2007 0
Instant Totals on Continuous Forms 4

Top