formatting a field which may contain different data types 1

[leishad]

I have the following fields:

Price - this is fine and formatted as currency
Price2 - created in query with the expression PRICE2: IIf([PRICE] Is Null,"**",[PRICE])

Problem: [Price2] will not display the [price] in currency format. I tried setting it thru properties but this does not work. And I tried using CCur([price]) within the iff statement with no luck as well.

 

[PHV]

You may try this:
PRICE2: IIf([PRICE] Is Null,"**",Format([PRICE],'Currency'))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[leishad]

That's it, thanks!