>I'm embarrassed to ask this:
>
>I can't figure out how to display a numeric value with the trailing zeroes trimmed. So, if the value is stored in the table as 88.99000, I want the value to display in a report as 88.99.
>
>Thanks,
>
>Yossi
It's not exactly what you're asking, but I use this technique:
lnValue=88.9900
IIF(MOD(lnValue,.01)=0,ROUND(lnValue,2),lnValue)
You could build it out like:
ICASE(MOD(lnValue,.0001)=0,ROUND(lnValue,4),MOD(lnValue,.001)=0,ROUND(lnValue,3),MOD(lnValue,.01)=0,ROUND(lnValue,2),lnValue)
Brandon Harker
Sebae Data Solutions