Dsum

[Simon]

I am trying to have a button on my order form that will work out how
much is outstanding on the order

on the form i have the total value of the the order and also have text

box that i want to dispaly the remaning amount.
I store all the payments in a subform.
The code i use works apart from when no payments are in the subform,
How can i change the code to make it work
RemainingToPay = Total - DSum("[Amount]", "tblPayments", "[OrderNumber]

= Forms![frmOrder]!OrderNumber.Value")

[Tom van Stiphout]

On 15 Nov 2006 09:51:41 -0800, "Simon" <S.*******@shos.co.ukwrote:

That's because if there are no records, DSum returns Null (which you
can test in the Immediate window), and any calculation with null
results in null.
So wrap an Nz() around it, and you should be golden.

-Tom.

>I am trying to have a button on my order form that will work out how
much is outstanding on the order

on the form i have the total value of the the order and also have text

box that i want to dispaly the remaning amount.
I store all the payments in a subform.
The code i use works apart from when no payments are in the subform,
How can i change the code to make it work
RemainingToPay = Total - DSum("[Amount]", "tblPayments", "[OrderNumber]

= Forms![frmOrder]!OrderNumber.Value")