>>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
>
>Looks kind of kludgy but......how about
>
>TRANSFORM(INT(myval))+IIF(myval-INT(myval)=0,"",ALLTRIM(TRANSFORM(myval-INT(ab)),'0'))

Thanks to all for your suggestions!