NULL IS 0

[DS]

Hi,
Is there anyway to make this Expression cough up a Zero if the field in
this Unbound Text Box is Empty or Null?
Thanks.
DS

CCur([Retail Price]*[Quantity Sold]*(1-[DiscountP])/100)*100-[DiscountD]

[Allen Browne]

CCur() can't handle the Null, so you will need to use Nz() twice:

CCur(Nz([Retail Price] * [Quantity Sold] * (1 - [DiscountP]) / 100, 0))
* 100 - Nz([DiscountD],0)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DS" <bo******@optonline.net> wrote in message
news:UL*********************@news4.srv.hcvlny.cv.n et...

Is there anyway to make this Expression cough up a Zero if the field in
this Unbound Text Box is Empty or Null?
Thanks.
DS

CCur([Retail Price]*[Quantity Sold]*(1-[DiscountP])/100)*100-[DiscountD]

[DS]

Allen Browne wrote:

CCur() can't handle the Null, so you will need to use Nz() twice:

CCur(Nz([Retail Price] * [Quantity Sold] * (1 - [DiscountP]) / 100, 0))
* 100 - Nz([DiscountD],0)

Allen,
Thank you once again! It works great!
DS