split a number

B

Brook

good day all...

how do I "split" a decimal number with a leading number and two decimals?
I.E. 4.75?

Thanks,

Brook
 
K

KARL DEWEY

Whole Number: Int([YourNumField])
Fraction: [YourNumField] - Int([YourNumField])
 
B

Brook

Thank you very much...

That worked perfectly!

Brook

KARL DEWEY said:
Whole Number: Int([YourNumField])
Fraction: [YourNumField] - Int([YourNumField])

Brook said:
good day all...

how do I "split" a decimal number with a leading number and two decimals?
I.E. 4.75?

Thanks,

Brook
 
Top