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
"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