>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'))