Running Total for Last Record

[Guest]

Please rescue me, I have created report for Account Receivable which consist
of Date, RefNo, Details, Debit, Credit and Balance fields. Balance is the
running sum of Debit Less Credit and it is appearing for all the records in
group, lets say for one customer 15 transactions are there, Balance will
appear on every row i need the running sum will hide for 14 records and will
show on the last record only.
Also I want to highlite the last record with yellow color which will
bifercate the customer, How i will do this one?

Thanks in advance

 

[Roger Carlson]

You need to create a Group Footer, put the control there, and set the
Running Sum property to Over Group.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L