insert previous balance into new record(arrears)

[shah1419]

Dear i am using this query to insert the previouse balance into arrears as shown in the figure. it will insert some record correct and some are not correct.pls help me.



SELECT fees.[gr no], sum((Admission+Registration+Fees.Tuition+[Fine]+Fees.Transport+[Exam]+[Misc])-Fees.Paid) AS bala
FROM fees
WHERE fees.balance<=0 and [gr no]=[gr no]
GROUP BY [gr no];

please see the attached file.

[June7]

Arrears is an aggregate value that should be calculated but not saved to table - same goes for Balance. Isn't Balance the amount due and therefore in arrears?

This type of running calc is not easy in query or on form. Aggregate calcs are best done on report.

[shah1419]

you are right. but i getting the following result.i need to know where i am wrong. pls see the attached fie.

[Missinglinq]

Everyone note that this problem has been triple posted, also being located at

http://www.access-programmers.co.uk/...d.php?t=258968

http://www.utteraccess.com/forum/Put...-t2013247.html

Linq ;0)>

[shah1419]

have you any idea to correct this query;

[June7]

I can't follow that example. There are no dates and the line points to -800 not -2000. A running balance is not something I have to work with. Maybe this will help you: http://support.microsoft.com/kb/290136