You can create a form or report, with the required format. It is needed to write VBA code based upon the dates given.
As u said If you require report from 01-jun-2010 to 31-aug-2010, which will be provided as inputs to form/report Then it is required to calculate the opening balance which is obviously the closing balance as on 31-may-2010. This can be done in two ways (i) using SQL code select sum(debit), sum(credit) from ledger where Date between fromdate and todate. (ii) using recordsource object/method where you get the required records and process the records one by one. This is only a skeleton. If you are comfortable with forms and reports, please design it and send a sample access file, so that I can add the required VBA code to suit your purpose. Regards, Kishan Reddy, K On Dec 6, 4:40 pm, Veer <[email protected]> wrote: > hi friends, > > i want to make ledger accounts in ms access. i am able to make ledger > for full period with opening balance but i m problem making ledger for > a specific period. for example i have full debit credit data from 01 > jan 2010 to 31 dec 2010 with opening balance. i can creat report for > full period with opening balance. but if i want from 01 june 2010 to > 31 aug 2010 i need opening balnce as on 1 june 2010 then all > transaction within period and closing balance as on 31 aug 2010. > > kindly give some idea in MS Access 2010. if u have any template please > provide. > > Thanks > > Veer -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to [email protected]
