One customer Many orders

[Ed3m]

Hi
I have a customer table and an order table. Customers can make many orders and for each order the total is calculated using a query. Is there a way to add together the combined cost of all orders for each individual customer and place it in a seperate table.
Thanks

 

[vconfused]

I would start by creating a plain Select query to display all of the customers and all of their orders amounts. Then click on the Totals button in the Toolbar, under CustomerID select Group By and under OrderAmt select Sum. This will display the total of the orders for each customer. Next change it to a Make Table query or an Update query (if you already have a table with the customer IDs).

 

[Ed3m]

Thanks that really helped

 

[vconfused]

If you have any problems, please let us know.

 

[Ed3m]

Hi again
Is there a way of adding the combined cost of all orders for each individual customer repeatedly automatically every 7 days or manually . For example if the current cost is 5 the new total would be 10 and then 15, 20 and so on.
Thanks