display fraction only in number

[Adam Jay]

Hi,
i created"Unbound"filed in Form to display only the decimal numbers
(fractions). Examble: the amount = 23,548.255 i want the unbound filed to
display only the fraction number .255 in the form. i used the following
(=Right([amount],3) it works ONLY for the amounts where thers is fractions if
there is amount with Zero Fraction 23,548.000 it gives me 548 NOT 000 !!!.
Is there any function can give me the fraction only for any amount i enter.
Thanks

 

[Rick Brandt]

Hi,
i created"Unbound"filed in Form to display only the decimal numbers
(fractions). Examble: the amount = 23,548.255 i want the unbound
filed to display only the fraction number .255 in the form. i used
the following (=Right([amount],3) it works ONLY for the amounts where
thers is fractions if there is amount with Zero Fraction 23,548.000
it gives me 548 NOT 000 !!!. Is there any function can give me the
fraction only for any amount i enter. Thanks

=[amount]-Fix([amount])

Fix() will return the integer (whole) portion of the value. Subtracting that
from the original value leaves just the fractional component value.