I have a expression in a query as below
QuoteUOM: IIf([UID]=1,[QuotePerTon]*[ConvRate]*[qrycustbagexw-new].[BagWtCorr],
IIf([UID]=2 Or [UID]=3 Or [UID]=11,[QuotePerTon]*[ConvRate],
IIf([UID]=4 Or [UID]=5 Or [UID]=6 Or [UID]=7,
[QuotePerTon]*[ConvRate]*Nz([DFL],0)*[finalgsm],[QuotePerTon]*[ConvRate]*[finalgsm])))
1. The properties section, of this expression, does not have the feature to change the format to currency. Can this be changed?
I want the value to show a currency with 4 decimal places - $8.0654
The format command using "currency" will show values with 2 decimal places and if I use the format expression with "0.0000", I will get 4 decimal place values but not the currency symbol!
What is the solution?
QuoteUOM: IIf([UID]=1,[QuotePerTon]*[ConvRate]*[qrycustbagexw-new].[BagWtCorr],
IIf([UID]=2 Or [UID]=3 Or [UID]=11,[QuotePerTon]*[ConvRate],
IIf([UID]=4 Or [UID]=5 Or [UID]=6 Or [UID]=7,
[QuotePerTon]*[ConvRate]*Nz([DFL],0)*[finalgsm],[QuotePerTon]*[ConvRate]*[finalgsm])))
1. The properties section, of this expression, does not have the feature to change the format to currency. Can this be changed?
I want the value to show a currency with 4 decimal places - $8.0654
The format command using "currency" will show values with 2 decimal places and if I use the format expression with "0.0000", I will get 4 decimal place values but not the currency symbol!
What is the solution?