Hi Guys
in the attached database there are 2 tables
table1 has records with the same id number, but different names, claims numbers and the network field
table2 has records with the same id numbers as in the first, network field, name field and claims
is there a way to update the second table's CLAIMS field with the sum of the claims from the first table based on the id number and the network
so the tables have to be joined by the id and the network, and the correct numbers in table2 CLAIMS field after updating should be
16
97
73
142
i tried sum, dsum, but i'm missing something
also, i know there's a way to do it in 2 steps, my question is if there's any way to do it in one query or one step
thank you!!!
in the attached database there are 2 tables
table1 has records with the same id number, but different names, claims numbers and the network field
table2 has records with the same id numbers as in the first, network field, name field and claims
is there a way to update the second table's CLAIMS field with the sum of the claims from the first table based on the id number and the network
so the tables have to be joined by the id and the network, and the correct numbers in table2 CLAIMS field after updating should be
16
97
73
142
i tried sum, dsum, but i'm missing something
also, i know there's a way to do it in 2 steps, my question is if there's any way to do it in one query or one step
thank you!!!