adding totals in a query

[redandblack]

ok i think it's best to start again....


ive got three tables. in each table there is a field for money (either recieved or spent).

now i need to get a total for each table and then add two of these totals together to form a new total.

the other untouched total will then need to be subtracted away from the newly made total

this needs to be presented in a query


please help me because this is SO hard

 

[Exodus]

Check my example

 

[redandblack]

i finished typing that then read ur example. thank you man. you have helped me solve a problem thats been bugging me for AGES!!!!!!!

 

[Exodus]

We both been typing while the others posting it can get a bit confusing.