Total Kg FIeld Calculation

[shazi9b]

Hello I Need help I want to create a field name Total KG which is sum of current kg amount




+previous total kg = new kg amount
my table is as


Date
Product Name
Quantity (for example current qty 10kg)
Total Quantity (10kg of this record + previous total kg) how to do ???
Rate (average Rate = total amount / total kg of previous records)

[June7]

Do this with a query, a nested query. http://allenbrowne.com/subquery-01.html#AnotherRecord

Recent thread on this https://www.accessforums.net/reports...2-a-38878.html