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
|
|||
|
|||
crediting or debiting an account
Hi all,
This is my first post here I hope it is clear - any help is useful I have a table with people's account balances. I want to be able to add money or subtract it from their accounts. What the best way so that amount is entered in a another input field and Access updates their account balance automatically? Thanks Bert |
#2
|
|||
|
|||
crediting or debiting an account
Well, most accounting systems treat balances as a dynamic value. That is,
each account has a (user entered) starting balance, then all subsequent credits and debits are recorded for that account and the running balance calculated (not stored in a table). A reconciled acct balance might be stored and used for the next reconcile process, but the current balance on forms/reports is the result of a query and calculation. Consider how MS Money, Quicken ,QuickBooks, etc. handle their info. There are also Access based business acct systems available for sale and customization. -Ed "Bert" wrote in message ... Hi all, This is my first post here I hope it is clear - any help is useful I have a table with people's account balances. I want to be able to add money or subtract it from their accounts. What the best way so that amount is entered in a another input field and Access updates their account balance automatically? Thanks Bert |
#3
|
|||
|
|||
crediting or debiting an account
Hi Thanks Ed for the reply but leaving money out of it - suppose I have a bin
of widgets, people take some out & people put some in - What is the best way to set up a table/query or form to do this just in Access (so the I input just the extra widgets put in or out) thanks Bert "Ed Robichaud" wrote: Well, most accounting systems treat balances as a dynamic value. That is, each account has a (user entered) starting balance, then all subsequent credits and debits are recorded for that account and the running balance calculated (not stored in a table). A reconciled acct balance might be stored and used for the next reconcile process, but the current balance on forms/reports is the result of a query and calculation. Consider how MS Money, Quicken ,QuickBooks, etc. handle their info. There are also Access based business acct systems available for sale and customization. -Ed "Bert" wrote in message ... Hi all, This is my first post here I hope it is clear - any help is useful I have a table with people's account balances. I want to be able to add money or subtract it from their accounts. What the best way so that amount is entered in a another input field and Access updates their account balance automatically? Thanks Bert |
#4
|
|||
|
|||
crediting or debiting an account
Every Accounting system has a transaction table. In that table, you would
want Debits and Credits/Ins and Outs. These are sometimes separate fields and sometime one transaction amount. They should contain fields something like: Widget TranDate Description INs OUTs Then a Totals Query could give you a balance by adding a calculated field "Bert" wrote: Hi Thanks Ed for the reply but leaving money out of it - suppose I have a bin of widgets, people take some out & people put some in - What is the best way to set up a table/query or form to do this just in Access (so the I input just the extra widgets put in or out) thanks Bert "Ed Robichaud" wrote: Well, most accounting systems treat balances as a dynamic value. That is, each account has a (user entered) starting balance, then all subsequent credits and debits are recorded for that account and the running balance calculated (not stored in a table). A reconciled acct balance might be stored and used for the next reconcile process, but the current balance on forms/reports is the result of a query and calculation. Consider how MS Money, Quicken ,QuickBooks, etc. handle their info. There are also Access based business acct systems available for sale and customization. -Ed "Bert" wrote in message ... Hi all, This is my first post here I hope it is clear - any help is useful I have a table with people's account balances. I want to be able to add money or subtract it from their accounts. What the best way so that amount is entered in a another input field and Access updates their account balance automatically? Thanks Bert |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Vlookup (kind of) in Access | Rubble | Running & Setting Up Queries | 4 | October 23rd, 2009 06:54 AM |
Outlook 2003 account problems. | EJL | General Discussion | 3 | May 3rd, 2005 12:09 AM |
Outlook 2003 Not using correct send account. | itsdreed | General Discussion | 2 | March 8th, 2005 01:59 PM |
How do I 'Bounce' Mail from Outlook? | redshoes | General Discussion | 5 | February 10th, 2005 05:07 PM |