Updating a table based on two tables

[isons via AccessMonster.com]

Hi everyone,

I have two tables i.e Bills, Payments. I issue bills to clients based on
table bills. When I receive payments from clients, I enter data using
Payments table. What I want is to create a third table say ledger based on
two table. I want this table updated whenever I issue bill. And enter details
for payments as well so that I will be able to get balance amount due to the
client. I will be obliged if anybody plz help and give any idea.

 

[John W. Vinson]

Hi everyone,

I have two tables i.e Bills, Payments. I issue bills to clients based on
table bills. When I receive payments from clients, I enter data using
Payments table. What I want is to create a third table say ledger based on
two table. I want this table updated whenever I issue bill. And enter details
for payments as well so that I will be able to get balance amount due to the
client. I will be obliged if anybody plz help and give any idea.

If the value in Ledger is calculated from the values in tables for bills and
payments... then the table Ledger *should almost surely not exist*.

Instead, create a Totals query, summing the bills and subtractint the sum of
the payments, to dynamically calculate the current balance due.

John W. Vinson [MVP]