ledger balance not shown

[Guest]

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

 

[John Spencer]

You probably need to use the NZ function to force a zero value when the
value of Sum Of Paid1 is null. Try the following

=[Sum Of Received1]- Nz([Sum Of Paid1],0)

 

[Guest]

Thanks John,

That has fixed the problem.

Regards,

David

You probably need to use the NZ function to force a zero value when the
value of Sum Of Paid1 is null. Try the following

=[Sum Of Received1]- Nz([Sum Of Paid1],0)

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