I have prepared a database in access ledger format and a report also prepared.It contains daytoday transactions of my office.problem is when generating a report for a specific period opening balance of that day is not availed.how can i solve this .
Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!
sarath_7026:
If you could provide the additional information in regard to where the issue stands, and if you need/want more assistance, I will gladly help. As your issue was so old at the time that I posted the response, I was simply trying to make sure you were taken care of, or that if you still needed help, I was ready to offer that. Obviously, no other expert was comfortable taking on an Access issue with the small amount of detail given, or it would have been answered when it was posted. I will be more than glad to help you if you still have an issue, as the problem depends on two things, primarily, the source of the balance (and how it is being called into the report), and the relevant date to be used for comparison to include it. Please post back if you need help; otherwise I would appreciate it if you would reconsider the rating you have assigned, as I don't believe that an offer to assist, when no one else has done so, warrants posting a "poor" rating to my offer to further advance your solution. Thank you for your consideration!
Agree poor rating not fair here. Moral of the story don't post an answer when you actually are requesting more information.
×
1,588 views
Usually answered in minutes!
thanks for your comment,
I create the tables in ledger database. It contains 3 tables, accounts, account types and transaction. In accounts name of bank and in account types the various accounts in those banks. Transaction table contains day to day transaction in these accounts. how can I get the opening balance of each account when generating a report for specific period. ie, for a report from 1-06-08 to 15-06-08 the opening balance is the closing balance of 30-05-08 ( (total deposit-total withdrawal) below the date 01-06-08) to be displayed on top of each account header.Please help. sample database may be posted if you required
Thank you
×