D
David
I have a problem with a clients' ledger calculation in circumstances when an
amount or amounts of money have been received but nothing has been paid.
The following calculation in my report in a text box calculates the
following -
Control source……………. =[Sum Of Received1]-[Sum Of Paid1]
If amounts of money have been received for the client they are correctly
totalled and if amounts of money have been paid then they are also correctly
totalled and the correct total ledger account balance is shown in the report.
However, if the client has monies received but no money paid then no balance
is reported, which of course is incorrect because the balance should be "Sum
of Received1".
Interestingly, when I use Access to produce a grand total of all of the
receipts and all of the payments for all clients then I get the correct
balance reported.
So the problem is that if no amount has been paid for an individual account
the balance, which of course should simply be the amount or amounts received,
is not reported.
I would be very grateful if somebody could help me with this problem.
Thanks very much.
David
amount or amounts of money have been received but nothing has been paid.
The following calculation in my report in a text box calculates the
following -
Control source……………. =[Sum Of Received1]-[Sum Of Paid1]
If amounts of money have been received for the client they are correctly
totalled and if amounts of money have been paid then they are also correctly
totalled and the correct total ledger account balance is shown in the report.
However, if the client has monies received but no money paid then no balance
is reported, which of course is incorrect because the balance should be "Sum
of Received1".
Interestingly, when I use Access to produce a grand total of all of the
receipts and all of the payments for all clients then I get the correct
balance reported.
So the problem is that if no amount has been paid for an individual account
the balance, which of course should simply be the amount or amounts received,
is not reported.
I would be very grateful if somebody could help me with this problem.
Thanks very much.
David