Updating using Sums from another Table. 
Author Message
 Updating using Sums from another Table.

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

Fri, 30 Jul 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Using SUM in SQL UPDATE command

2. Using--After Update-- to update field in table.

3. Updating Tables with SQL in VB6 using vfoxpro tables

4. Using a defined Variable to Update a Table using DoCmd.RunSQL

5. Help Updating table by using a recordset

6. Update a field in each record of a table using a recordset

7. Update table from form using code.

8. Updating Field From Another Table Using Random

9. Cant update SQL 7.0 Tables using VB.

10. Using SQL commands in VBscript to update ACCESS table

11. Batch update for multiple tables using single ADO Recordset (VB )

12. Unable to update joined table using DataEnvironment in VB6


Powered by phpBB® Forum Software