zibzaba
01-09-2010, 04:11 AM
hello i m new to access 2007
plz help me in the calculation of running total
i want running total of each customer for duplicate dates in table , customer orders.
i have attached my db
In the table customers orders,
Amount=unit price*quantity
and
Amount Due=Amout-Amount Paid
I have only one problem:
i want running sum of field "Amount Due" in the field "Balance" for each customer.
thats all my problem
for the last whole week i have been trying but all in vain
plz help me in the calculation of running total
i want running total of each customer for duplicate dates in table , customer orders.
i have attached my db
In the table customers orders,
Amount=unit price*quantity
and
Amount Due=Amout-Amount Paid
I have only one problem:
i want running sum of field "Amount Due" in the field "Balance" for each customer.
thats all my problem
for the last whole week i have been trying but all in vain