Solved VBA to update a table with the sum of a field in another table (1 Viewer)

[Capitala]

Thanks for your persistent support.
I have a table (transactions) with the columns: date; description, debit, credit and cost center. The second table is: Cost centers summary with the columns: const center and balance
I need a vba code to update the sum of credit (for example) into the table (cost centers) based on cost center
Best Regards

 

[arnelgp]

it is not necessary to save Calculated values. you can calculate it on the fly (see Query1).
but if you want to save it (see your form).

 

[Capitala]

it is not necessary to save Calculated values. you can calculate it on the fly (see Query1).
but if you want to save it (see your form).

Thanks for your kind reply and directives. However, for some reason I need to do that by a vba code like: docmd.runsql ("update cost centers ....... set cost centers.debit=sum of( a field in a table or query). Is it possible?

 

[arnelgp]

see your Form, i already made code to update your cost center table.

 

[Capitala]

see your Form, i already made code to update your cost center table.

Thanks a mile