Summing Amount party wise

[mahju]

Dear Members

I have 6 total queries totling amount on party basis (6 individual tables.

Now I am trying to evaluate (Plus or minis) the amount on party wise and appen it to another table (Trial Balance).

In query No. 7 i have tried something but failed.

Help me to solve the problem. (File attached)
Any query or code will do

Regards

[mahju]

Dear Members
I have solved it myself

Take two tables at a time and create total query on party .
Then another query with the above and a new one and so non.
If you have query too comp;lex error, append the result of previous query and then continue with that table and another neew one.