I am trying to use an UPDATE query to update Total Balances and Total
Payments in a main Clients Table from the Sum of the Payments and Deposits
in another table. I can do this with a loop, but I was just wondering if it
can be done through an UPDATE.
        The Clients table has a Unique ClientNo, but the Payments table has a many
to 1 relationship with the Clients table ( many Records can refer to 1
Client). Also, to save space I use a Paid flag to stipulate whether or not
the AmtPaid is a Deposit or a Payment.
        Can anyone help me ???

--
William Bailey
BOSS Information Technology Services
http://www.*-*-*.com/ ~bossinfo