crediting or debiting an account

B

Bert

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
 
E

Ed Robichaud

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
 
B

Bert

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
 
K

Klatuu

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
 
Top