balance B/F in access

[asif amin]

I ll be very thaknkful if somebody will help me to complete my project

" I hv created an database of accounts on ms access in which i hv created running balance report.But unable to get the beginning balance of any any give pariod.'

i hav fields in table "Transaction" in which fields are "date" "Reference no" "main category" "account head" "debit" "Credit"

from these created running balance in report

i need this running balance make me able to transfer closing balce to next opening date as i define in the date query.

awaied help

asif


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown List - XML
http://www.eggheadcafe.com/tutorial...923-2457fe12d1cb/aspnet-dropdown-list--x.aspx

 

[Daryl S]

You can only calculate the ending balance if you have a starting balance. Do
you have a table that stores that figure (or do you assume a starting balance
of zero)? You can add/subtract all your transactions, but you need to have
the amount you started with in order to calculate your ending balance.

You will need to post more information if you want more help.

 

[Mike Painter]

The beginning balance is the ending babance of the previous period and that
is the algebriac sum of all transactions with a date less than the start
date of the period.

A query will do this.

 

[swas]

Asif,

I found the following helpful,

http://allenbrowne.com/AppInventory.html

Though stock not cash transactions, the principle is the same.

Regards

swas