Put an Balance into Arrears

[shah1419]

Respcted,
i am facing a problem.i want to insert balance amount into arrears column for every record.i have insert the january fees and the parents have paid less amount from the challan.when i insert the Febuary fee and insert the balance amount in Arrears coulmn for each record.Please see the attached file...
pls advised me.
Regards

[June7]

This is easiest done on reports because there a textbox has a RunningSum property.

For a form, Google: Access form running sum
Review:
http://www.tek-tips.com/faqs.cfm?fid=5248

[shah1419]

but i want in form

[June7]

Calculating with value in another record of same table is not simple. In addition to the link already provided review http://allenbrowne.com/subquery-01.html#YTD. Also, if user is allowed to sort and/or filter the form records, the running balance could be wrong.

Could try something like:

Nz(DSum("Nz([Adm],0)+Nz([Reg],0)+Nz([Tuition],0)-Nz([Paid],0)", "tablename", "GRno=" & [GRno] & " AND DateEnter<=#" & [DateEnter] & "#"),0)