Running Totals with a difference

[wwwredback via AccessMonster.com]

Hi all,

I am trying to display some results within a form which I use to create
invoice(orders) so it is used as a running total to date for each customer.

Here is the code I have used:


Qry_GroupOrders_ForTotals

SELECT Sum([Order Details Extended].ExtendedPrice) AS SumOfExtendedPrice,
Orders.OrderID, Orders.CustomerID
FROM [Order Details Extended] INNER JOIN Orders ON [Order Details Extended].
OrderID=Orders.OrderID
GROUP BY Orders.OrderID, Orders.CustomerID
ORDER BY Orders.CustomerID;

Then I’ve got a separate query which finds the information from the above
query called:

qry_RunningTotal

SELECT Sum(qry_GroupOrders_ForTotals.SumOfExtendedPrice) AS
SumOfSumOfExtendedPrice, qry_GroupOrders_ForTotals.CustomerID
FROM qry_GroupOrders_ForTotals
GROUP BY qry_GroupOrders_ForTotals.CustomerID
ORDER BY qry_GroupOrders_ForTotals.CustomerID;

This then gives the totals per customer for all their orders.


The questions are:

1. How do I display this result in the form without it blocking data entry
and
2. Also the 2 queries will need to be refreshed for every invoice (order)
created.

Any help will be gratefully received.

Thanks

James.