no record condition

[krishnanhemanth]

i have a textbox on a form that looks up value form a table using dsum

the form is --- payments
the text box is--- advance payments
the table is ----advance payments entry

i use this code t get the sum of all advance payments made wrt ponumber
=IIf(IsNull([PONUMBER]),0,DSum("[VAAMOUNT]","VENDORPAYADVANCE","[PONUMBER]=" & [PONUMBER]))

the above code works all right if any advance payments are made
but if no advance payments are done for a particular ponumber then
the textbox shows blank
i want the textbox to show zero

please help
hemanth

 

[John Big Booty]

Have a look at the NZ() function.