Blank in Listbox

D

DS

I have this field in a Query.....
PRICE:
CCur(IIf([CDDiscountDP]=1,[CDFinalPrice]+[CDDiscountAmount],IIf([CDDiscountDP]=2,[CDFinalPrice]-([CDFinalPrice]*[CDDiscountPercent]),IIf([CDDiscountDP]=3,"
",[CDFinalPrice]))))

Under the condition CDDiscountDP=3 I would like a blank to show up instead
of $0.00 however when I code it as above I get an error that you can't do
it. When I change it to CDDiscountDP=3 (0) it works. Any way that I can
get a blank instead of a $0.00 ?

Thanks
DS
 
D

DS

I figured it out. I moved the CCur phrase inward and excluded the
CDDiscountDP=3 from the CCur part and put it at the begining of the
expression.
 
Top