Need Customer Previous Account Balance

[Nadeem148]

I have this data. and i need "Arrears" Field automatically update on next transaction if customer did not paid. Simply says, the "RemBal" Field of previous month or date for every customer comes to "Arrears" field on every next transaction/date or month of concern customer.

CustomerID_FK	TransDate	Arrears	CurrentBill	Discount	NetDueBill	NetPaid	AfterDue	RemBal
1	30-May-19	0.00	130.00	0.00	130.00	0.00	150.00	150.00
1	30-Jun-19	0.00	130.00	0.00	130.00	130.00	0.00	0.00
2	30-May-19	0.00	130.00	0.00	130.00	0.00	150.00	150.00
2	30-Jun-19	0.00	130.00	0.00	130.00	0.00	150.00	150.00

Kindly Help me.

[June7]

This should be calculated when needed.

Accomplishing in query would be complicated, review http://allenbrowne.com/subquery-01.html#AnotherRecord

Best place to do this calc is on reports utilizing RunningSum property of textbox.

Unless you want to run some VBA code that would go find the data and save into record.

Duplicate post https://www.accessforums.net/showthread.php?t=77423