Help Need

[Omer Aslam]

I want the query or any other formula for this result..


Net_Total (in 1st row) = Price (of 1st row) - Discount (of first row) and
Net_Total (in 2nd row) = Net_Total (of 1st row) + Price (of 2nd row) - Discount(of 2nd row) and
Net_Total (in 3rd row) = Net_Total (of 2nd row) + Price (of 3rd row) - Discount (of 3rd row)....and so on

see the picture

[RagJose]

Without a bigger picture, it seems Excel would suit your need better... In a Form or query, AFAIK you cannot define references to a previous record.

[Omer Aslam]

but i need this in access not in excel

[ssanfu]

You can reference the previous record, but not using the current info provided. See Method 2 at http://support.microsoft.com/kb/210504

There needs to be a field that can be sorted in ascending order - ie a date field (but not an autonumber type field)

[Omer Aslam]

i need exact formula for my scenario