EXTRACT NUMBERS AFTER DEC. POINT.

[jobillborf]

Hi. I have a database with a numberic field. I would like to only extract the numbers before the decimal point.

For example 7.15 would be .15

Thank you for your help

 

[bdreed35]

Try creating a formula with this:

(table.field} - Int((table.field})

~Brian