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

 

Ashfaq-

The balance as I suggested you calculate it gives you the the running balance for all transactions.  If you just want the "net" of debits and credits easy day, simply need to filter on the current date  Then your query will look something like:

SELECT TransDate, CreditAmount, DebitAmount, 

(SELECT Sum([CreditAmount] - [DebitAmount]) 

FROM Transactions As T2

WHERE T2.TransDate = Transactions.TransDate) As DailyBalance

FROM Transactions 

ORDER BY TransDate, TransactionID;

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 30, 2014, at 1:01 PM, Qazi M. Ashfaq <qaziashfaq@gmail.com> wrote:

Thanks for your response and guidance.

Please help me out in my case. as i have to sort out all totals per day (total of each date), please explain following portion as u illustrated:

Transactions As T2 

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

FROM Transactions

Regards,

Ashfaq

Mob:  +92 331 5333240

Contact me: 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (4)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___