Query question outstanding balance

S

Spencer Hutton

In managing an organization i have a "Members" table linked to a
"MemberLedger" table. the members table stores contact info, etc... in the
ledger table, each record is a trasaction against each members' account:date,
description, charge,payment, etc. i want to keep a running balance on each
member based on their charges and payments. should i set up a field in the
members table called "AccountBalance" if so, how do i acheive this
calculation. Access newbie.
TIA
 
V

Vincent Johns

Spencer said:
In managing an organization i have a "Members" table linked to a
"MemberLedger" table. the members table stores contact info, etc... in the
ledger table, each record is a trasaction against each members' account:date,
description, charge,payment, etc. i want to keep a running balance on each
member based on their charges and payments. should i set up a field in the
members table called "AccountBalance" if so, how do i acheive this
calculation. Access newbie.
TIA

I suggest that you keep a STARTING balance (e.g., as of the beginning of
the calendar year or membership year) in a Table somewhere, either in
[Members] or in a Table linked to it, but calculate the running balance
based on that and on the subsequent transactions recorded in
[MemberLedger]. If you try to keep the running balance in the [Members]
Table, you'll be forever changing it, whereas the records in
[MemberLedger] are likely to be fairly stable. (You might have to
change one occasionally to correct a mistake, but I think that's about it.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top