Summing a table 
Author Message
 Summing a table

I am using Vb 6.0 and access 97 and I am using ADO.  I want to do is have a
cmd button in my form when press  will summed up from my customer detail
table (custdetail) to my customer sum table (custsum).  I am in the
insurance business.  I have four fields that are index and I want the
summing based on the order of these fields.  1. Treaty Yr, 2. CA code 3. QS
code  4. Insured.  For example when there is a match for Treaty Yr with the
corresponding CA code and corresponding Qs code and the corresponding
Insured, customer sum table will be added.  Before the summing takes place I
want to delete all the records in customer sum table then summed them up.
The file is call CAQS.mdb in C: drive.  I am a newbie, Any help will be
appreciated.  Thank You.

Thu, 25 Apr 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. table join with a sum works in sql

2. doing sums in a table outlook view

3. calculating sums in a table formated view !

4. SUM from a table in a variable

5. Need help with joined table sum query

6. ~Sum existing values with values from another table

7. Updating using Sums from another Table.

8. ~Sum existing values with values from another table

9. AM I missing something - Sum and Cumulative Sum

10. Report showing BOTH Aggregate Sum of Display records and Total Sum by Group

11. How to sum a single fiscal period for monthly expenses and also sum ytd expenses

12. Sum in Excel from Access


Powered by phpBB® Forum Software