How does the IIF function display decimal places?

[badmem]

I have a query that uses a calculated field DISPDDE: IIf([DDEROUND]<0.1,"M",[DDEROUND])



The DDEROUND is a calculated field. It displays the result to one decimal place - 0.4, 1.0, 1.4 etc. The IIF result shows 0.4 and 1.4 correctly, but 1.0 shows as 1, not 1.0.

Is there any way to display this correctly?

Thank you.

[ranman256]

you can format DDEROUND to show any # of decimals you want.
The IIF doesnt handle formatting, it reads the real number.

[CJ_London]

you have another issue - if DDEROUND is < 0.1 then it returns a number, otherwise it returns text. Mixing datatypes in this way is looking for trouble.

suggest

DISPDDE: IIf([DDEROUND]<0.1,"M",format([DDEROUND],"0.0"))

which will convert your number to text to display 1dp

[badmem]

Thank you for your very fast replies. The result of the IIf will only be used to print a report - it won't be used for any calculations. I hope that will avoid problems with the mix of numbers and text. We don't want "0" to show on the reports, so <0.1 is shown as "M" - below reporting level.

The DDEROUND calculation is formatted to FIXED 1 decimal place and shows the correct result 1.0. I was surprised that IIf misses off the ".0" but displays other decimal points correctly. I'll try putting the format statement in the calculation as suggested.

Thanks again.

[badmem]

Putting the Format command into the query worked - the numbers are showing as 1.0 now.

Thanks again