If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
closing and opening balence
i have two tables table 1 bank transaction field Deposit (currency) " withdraw (currency) " date (date) table two expences field item (text) " expences (currency) " date (date) now how to take the Closing balence and opening balence for the year that is closing balence of the previes year(1/1/01) to (31/12/01) is the opening balence for the year(1/1/02) to (31/12/02) & it contionues cash in bank and plus as follows FORMULA opening balence= previes year (sum( withdraw)-(sum(expences)) closing balence =( opening balence)+(presentyear(sum(withdraw) - _ present year(sum(expences)) and this chain will continue how to do this please using query's balu |
Thread Tools | |
Display Modes | |
|
|