By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,469 Members | 982 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,469 IT Pros & Developers. It's quick & easy.

Refer to account Table

P: 1
Hello guys!! I have ms access project, I need to create a program that will help me manage my income and expenses, On this i have created three tables, tblIncome, tblExpenses and tblAccount! I need when entering the data in Income form! The amount to go direct to the Account! And in Account form i have entered Bank accounts and the respective amount! My Question is! How can the amount be deducted from the Accounts when i enter the expenses! Because in the expenses form there is a combobox that shows the account i want the amount to be deducted from! So from there i need when i choose the bank from the combobox the amount to be deducted from Account Table
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,385

Welcome to Bytes!

I would recommend having all transactions in one Table and calculate balances at run time in your forms and reports.

Even better, the headaches involved with trying to develop your own MS Access accounting project are not worth it. You can get an inexpensive off the shelf software package that will do you much better in the long run. There might even be some free options.
2 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.