Calculate a balance

[ianna]

HI everyone


I really really really need your help !

I'm making a report (Report1) containing these fields:
Account ID (field from query "Client")
Payments Sum (field from query "Payments")
Withdrawal Sum(from query "Withdrawal")
Balance (field from query "Client")

So what I want is in the Balance field to have the sum of = Payments Sum-Withdrawal Sum. In the table at the Balnace field i haven't been able to insert a syntax/formula to have as a result Balance= Payments Sum-Withdrawal Sum.

Should I build a query for the Balance but how to build it (functions) ?
Please help me...

Thx