Query for sum fields

[Mohamed Ali]

I'm trying to create a query that can sum values of different fields in different tables
can some help me plz!

there is another issue:
Can I sum values of a field and put the result into another field in different table?

 

[Mohamed Ali]

thnx for ur answer

but I have multiple table and I want to get sum of fields in different table
for example:
table1 has (ID,payment) ... table 2 (ID,payment) .... table3 (ID,payment)

and there is a relationship between every single table and a customer table
so I want to sum all the payment values for every single customer
is that possible?

thnx in advance