Format Problem

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
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
 
Back
Top