General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
Likes (1)
Naomi Nosonovsky
>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'))
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only