Trim "like" function for a number?

[dbielenda]

I have two fields that are a number in the database that is to be displayed on my report as:

Priority Range: 1 to 9

I tried using this formula:
totext({SSSP030A.FROMPRI}) + " to " + totext({SSSP030A.TOPRI})

However on my report it appears as:
Pritority Range: 1.00 to 9.00

How can I get rid of the decimal places? Can I use a function similar to trim?

Thanks! s-)

 

[alley211]

You can do this instead:

totext({SSSP030A.FROMPRI},0) + " to " + totext({SSSP030A.TOPRI},0)

That will take out the decimal places.

If you were dealing with numbers in the thousands you would want to do this:

totext({SSSP030A.FROMPRI},0,"&quot + " to " + totext({SSSP030A.TOPRI},0,"&quot

alley

 

[Ngolem]

use it this way

totext({SSSP030A.FROMPRI},0) + " to " + totext({SSSP030A.TOPRI},0)


Jim

 

[dbielenda]

Worked like a charm. Thanks alot.. why didn't I see that? X-)