Re: [MS_AccessPros] Help required in Opening/ Closing Balance in MS Access Report

 

Hello name?

Any "running balance" like this requires subqueries to show the current total.  Something like:

SELECT TransactionID, TransactionDate, DebitAmount, CreditAmount, 

(SELECT Sum(CreditAmount - DebitAmount) FROM Transactions As T2 

WHERE T2.TransactionDate <= Transactions.TransactionDate) As Balance

FROM Transactions

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Mar 28, 2014, at 4:02 PM, qaziashfaq@gmail.com wrote:

Hi All, Help required regarding calculating and showing total and opening balance and closing balance for each date. I am attaching sample data.

https://xa.yimg.com/df/MS_Access_Professionals/sample+cashbook.xlsx?token=pjXtUzqxD8XW7L0kNwkBY1MgfLgIbpZoRMZGomO7uG3WMzRZXdKHc7yl8LMyp8dS6wy7_lgcd21DxSLse2u1J-2rihpySqoqFFxviMT2hL0I4apiTA&type=download

Your early response will highly be appreciated.
Regards,

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___