Report Null and Nz problem

[Guest]

I have a report called Statement, I am using this expression to calculate and
display all payments made to each order:

=IIf(IsNull([OrderID]),0,DSum("[PaymentAmount]","[Payments]","[OrderID]=" &
[Reports]![Statement]![OrderID]))

I need it to also display $0.00 when there has been no payments made. How
wo I use the Nz function in the expression above? Also when I try to create
a Total Due on the report footer, it doesnot work. Is it because of the Null
problem in the expression above. I Think if I can get the Null problem
solved, everything else will work, I hope.

 

[Guest]

Sorry to have posted this twice

 

[Marshall Barton]

I have a report called Statement, I am using this expression to calculate and
display all payments made to each order:

=IIf(IsNull([OrderID]),0,DSum("[PaymentAmount]","[Payments]","[OrderID]=" &
[Reports]![Statement]![OrderID]))

I need it to also display $0.00 when there has been no payments made. How
wo I use the Nz function in the expression above? Also when I try to create
a Total Due on the report footer, it doesnot work. Is it because of the Null
problem in the expression above. I Think if I can get the Null problem
solved, everything else will work, I hope.

In this case, you could use it in front of any of the other
function calls ;-)

Here's the way I would do it:

=IIf(IsNull(OrderID),0,Nz(DSum("PaymentAmount","Payments","OrderID="
& OrderID), 0))

 

[Guest]

THANKS, looks like my problem was where I was putting "0" in the expression.
You have given me back my sanity, now all I have to do is get the Total Due
for the statement to work. Thanks again

I have a report called Statement, I am using this expression to calculate and
display all payments made to each order:

=IIf(IsNull([OrderID]),0,DSum("[PaymentAmount]","[Payments]","[OrderID]=" &
[Reports]![Statement]![OrderID]))

I need it to also display $0.00 when there has been no payments made. How
wo I use the Nz function in the expression above? Also when I try to create
a Total Due on the report footer, it doesnot work. Is it because of the Null
problem in the expression above. I Think if I can get the Null problem
solved, everything else will work, I hope.

In this case, you could use it in front of any of the other
function calls ;-)

Here's the way I would do it:

=IIf(IsNull(OrderID),0,Nz(DSum("PaymentAmount","Payments","OrderID="
& OrderID), 0))