no record scenario

[krishnanhemanth]

hi all

i have a textbox "advance pay" on a form "PAYMENTS"

This text box is unbound and gets its value using dsum
the expression is......
=IIf(IsNull([VAAMOUNT]),0,DSum("[VAAMOUNT]","VENDORPAYADVANCE","[PONUMBER]=" & [PONUMBER]))

vendorpayadvance --- table
vaamount --- field in the above table
ponumber --- ponumber is the criteria that need to be satisfied

the above works fine if there is data in the table wrt ponumber
but....
if there is no data for a particular ponumber in the above table then ...
the textbox "advancepay" on the form "PAYMENTS" IS BLANK instead of showing ZERO...

HOW SHOULD I MAKE IT DISPLAY ZERO

PLS HELP

hemanth

 

[vbaInet]

Like:

Nz(DSum(...), 0)

 

[krishnanhemanth]

thanks vbainet... you hit the bulls eye

thanks again

hemanth

 

[vbaInet]

You're welcome!