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

 

[Marshall Barton]

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.

A field (column) in a query can only have a single type.
You are trying to make it a Currency type in sone records
and Text in others (the Format function always returns a
string). The resulting type of your ambiguous expression is
whatever Access/Jet guesses it should be, most likely Text).

Maybe you want the field to be formatted as text in both
cases??

PRICE:IIf(CDDiscountDP=1,FormatCurrency(CDQuantity*CDDiscountAmount,2),FormatPercent(CDDiscountPercent,2))

 

[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