Format Problem

[DS]

I have a column in a Query that is giving me problems.

PRICE:
IIf([CDDiscountDP]=1,CCur([CDQuantity]*[CDDiscountAmount]),FormatPercent([CDDiscountPercent],2))

If CDDiscountDP =1 then the fiield is of a dollar amount otherwise its
Percentage. I'm just getting a regular number back.
Thanks
DS

 

[DS]

Perfect, works great! Since this is for display only I just need it to
appear as such instead of it really being as such.
Thanks
DS