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
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